Erro in Subform in Ms Access Reports
Hi All!
I have a question that i have designed a report in ms access and I put a subform and linked it with the Party Group, I have put vb codes to use calculate some values if value on subform is null then VBA debug for error, I have used below all function but not solution is there:
NZ(), Val(), IIF(), isNull(), IsEmpty(), IsError()
Exampl of VBA:
Text10 = [subform].Report_Name.Text30 + Text20
if textbox on subform is null then error is there.
please provide solution......
Software/Hardware used:
Ms Access Reports
I have a question that i have designed a report in ms access and I put a subform and linked it with the Party Group, I have put vb codes to use calculate some values if value on subform is null then VBA debug for error, I have used below all function but not solution is there:
NZ(), Val(), IIF(), isNull(), IsEmpty(), IsError()
Exampl of VBA:
Text10 = [subform].Report_Name.Text30 + Text20
if textbox on subform is null then error is there.
please provide solution......
Software/Hardware used:
Ms Access Reports
ASKED:
November 15, 2009 7:34 AM
UPDATED:
November 16, 2009 6:33 PM
Answer Wiki:
Last Wiki Answer Submitted:
Be the first to answer this question.
All Answer Wiki Contributors:
Be the first to answer this question.
To see all answers submitted to the Answer Wiki: View Answer History.
You will need to post at least the error message, and your code.