M
mot98
Hi All,
I am trying to use the DLOOKUP command in my VBA code.
Basically I want it to lookup my query and if there are no records to
skip the rest of my code.
Here is what I am using:
If dlookup(1, "Get_All2") < 0 Then
Call Do_Nothing
End If
But it is not working....my code is still being run.
I have double checked the table the query is pulling from, and there
are no records.
I am trying to use the DLOOKUP command in my VBA code.
Basically I want it to lookup my query and if there are no records to
skip the rest of my code.
Here is what I am using:
If dlookup(1, "Get_All2") < 0 Then
Call Do_Nothing
End If
But it is not working....my code is still being run.
I have double checked the table the query is pulling from, and there
are no records.