No Form pop-up if Query is Null

  • Thread starter Thread starter Brook
  • Start date Start date
B

Brook

I have a form that is populated from a Select Query Based
on a Company ID table that contains Company ID, Company
Name, Notes.

When the user clicks the Run Query Button and there is not
information in the Notes column, I don't want the Form to
appear.

Does anyone have any ideas?

Brook
 
Brook,

For a start, in the Criteria of the Notes field in the query that the
form is based on, put:
Is Not Null
Then, you can use an expression like this...
DCount("*","NameOfQuery")>0
.... to determine whether the form will open. The details of how to do
this will depend on the method you are using to open the form, which is
not clear from your post.
 
Back
Top