open query if result is not null

[tagteam]

When the user opens a form I would like to run a query. If that query returns any results I would like it to open and if it does not I dont want the window to open. I can open the query easy enough, i am just not sure how to get it to not run / open if the query doesn't return any records.

[June7]

Users should not interact directly with tables and queries, only forms and reports. Use the query as source for a report.

Review http://access.mvps.org/access/reports/rpt0006.htm

[tagteam]

That works with reports and message boxes but i tried it with a form and it did not work. This is the code I have on the forms on open event

  DoCmd.OpenForm "f_AlertResults", , , "RailcarID = " & Me.RailCarID
       If Err = 2501 Then Err.Clear

[June7]

You said you wanted to run a query and I assumed this to mean open a SELECT query, so I suggested a report bound to that query. What is this query you want to 'run'?

Is user selecting this RailCarID in a combobox? Could limit the combobox list to only those RailCarID values that have related records.

Otherwise, review http://allenbrowne.com/RecordCountError.html

[davegri]

In the form's open event:

If Dcount("*", "YourQuery") > 0 then
    docmd.openquery "YourQuery" 
endif

Is the query the recordsource for the form? In that case it makes no sense to me to open the query at all.
If the query is the recordsource for the form, and your goal is to not open the form is the query is empty, you can check the dcount from whatever code opens the form.

[tagteam]

Thanks Devegri, that is working nicely for me