Object Required (2) 1

[jossimon]

I have the following code and it looks right to me but it keeps bugging out and saying, "Object Required"

If IsNull(TUnMatchDC.ShipTo) = False Then
DoCmd.OpenForm "F_UpdateDCX_Ref2", acViewNormal, acEdit
End If

Its a simple enough If statement, but this is the second "Object Required" that I get on an If statement and I have no idea what I am suppose to do with that.

 

[PHV]

What is TUnMatchDC ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[jossimon]

Its a table name. ShipTo is the field that I am looking at. Basically, what I am trying to do is...
If the table is populated, then open that form, otherwise, don't open the form.

 

[HitechUser]

If NOT IsNull(TUnMatchDC.ShipTo) Then
    DoCmd.OpenForm "F_UpdateDCX_Ref2", acViewNormal, acEdit
End If

There....

 

[PHV]

If Not IsNull(DLookUp("ShipTo", "TUnMatchDC")) Then

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[jossimon]

Still got the error "Object Required." Thank you for your help though.

 

[PHV]

Still got the error "Object Required."
And what is highlighted now ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[jossimon]

PHV:

Thank you for your DLookUp Solution... It worked. Still learning all of this VBA and I don't have training scheduled until March 2. I have to get this DB out before then, lucky me! This website is great for help. I really appreciate you taking the time to help me.

jossimon