error object required

[edojan]

Hi

I have a from with this code under one of the command buttons:

Dim pp1 As String
If AUDIT_QUEUE Is Null Then pp1= pp1 & " Please Fill in Audit Que" & vbCrLf
If [from date] Is Null Then pp1 = pp1 & " Please Fill in From Date" & vbCrLf
If [thru date] Is Null Then pp1 pp1 & " Please Fill in Thru Date" & vbCrLf
If PaidAmount Is Null Then pp1 = pp1 & "Please Fill in Paid Amt" & vbCrLf
msgbox pp1

I want the code to create entries in the string pp1 and at the end of the code to display message box with each error on its individual line ... i get error saying object required. Please tell me what i am doing wrong.

thanks!

 

[boblarson]

Dim pp1 As String
If IsNull(Me!AUDIT_QUEUE)l Then pp1= pp1 & " Please Fill in Audit Que" & vbCrLf
If IsNull(Me![from date]) Then pp1 = pp1 & " Please Fill in From Date" & vbCrLf
If IsNull(Me![thru date]) Then pp1 pp1 & " Please Fill in Thru Date" & vbCrLf
If IsNull(Me!PaidAmount) Then pp1 = pp1 & "Please Fill in Paid Amt" & vbCrLf
MsgBox pp1

 

[Rabbie]

Try this. It may work

Dim pp1 As String
If isNull(AUDIT_QUEUE) Then pp1= pp1 & " Please Fill in Audit Que" & vbCrLf
If isnull([from date]) Then pp1 = pp1 & " Please Fill in From Date" & vbCrLf
If isNull([thru date]) Then pp1 pp1 & " Please Fill in Thru Date" & vbCrLf
If isnull(PaidAmount) Then pp1 = pp1 & "Please Fill in Paid Amt" & vbCrLf
msgbox pp1

 

[edojan]

Thanks! Worked great!!!