Test query results before displaying on the form

[Tvanduzee]

Hello
I have a form that will display Work Order Numbers in a cbo. These work orders are Provided via query to the form cbo. It only displays WOs where the client name is blank (Which means it is an unused Work Order). How can I test the results of the query before it displays a blank cbo (Meaning that there are currently no new Work Orders Generated). I want to have a msgbox come up and instruct the user to generate new Work Orders before trying to create a new one on the form. (Which means the user opens another form to generate and print work orders). Once the Work Order numbers are generated, they will be available in the forms cbo.

Ex: If the user clicks the "New Work Order" Button, it makes visible the cbo to offer available work order numbers. But if they have not generated them in advance, it will show up blank. I don't want them to see a blank cbo. So, when they click the "New Work Order" button, I need it to test the results of the query before displaying the results to the cbo. If the recordset is blank, then they will be prompted to generate new work order numbers first. If there are available work orders, then the results simply get displayed to the cbo.

The on click for the add new work orders is using vba with the docmd to start a new record.

Hope this is clear enough to understand.

Thank You


Terry

[pbaldy]

If DCount("*", "QueryName") > 0 Then