Select Query problems?

[JimUK]

I am using a simple Select Query where I am trying to find a particular (text field) record, which is not a problem. The problem is that I do not want to view the form that the query is calling if there is no matches. A blank form shows up now. I tried a macro that will bring up a msg box if the field is null or rather empty string but when would I run this? It actually needs to run when the query does. Anybody steer me in the right direction?

Thanks,

Jim Norris

 

[DougP]

In the On_current event of the form
put this which is similar to your same macro expression

If IsNull(Myfield) Then
DoCmd.Close
End If

that should close the form before it opens
Or where ever you call the form from. DougP, MCP
dposton@universal1.com

Ask me how Bar-codes can help you be more productive.
Or visit my WEB site

http://www.barcodeone.com

 

[JimUK]

On the same vein could I then run a macro "On Close" that would pop up a Msg Box saying that record was not found?

Thanks,

Jim