Opening form based on query result

[m0use]

Hi there!

Is there a easy way to get a form opened, based on a query result?

I only want forms to open when the result of the query is true and data is returned. Otherwise there would be nothing to see, right...?

(I do know I can use RecordCount in VB, but I wonder if there isn't an easier way to do this.)

Any suggestions anyone?

m0use

 

[Navyguy]

Perhaps you can try the NZ(DCount) function. I had lots of help with this from the forum and it works great. I use it to search for three separate criteria and if all are present it opens the form with the required data. If any one of the three fields are not present a custom message box displays and the form does not open.

This is not exactly a query but it may suit your needs. Give a search for the NZ(DCount) function.

Navyguy

 

[m0use]

Navyguy,

Thanks a lot!

This is exactly what I need. Worked like a charm.
I did not think of using DCount this way...

Thanks again, m0use

(BTW, this is a GREAT forum!!!)