I have a form with a subform. I want to look at the items user has entered and if certain items are present.....pop-up window saying "Please run XXXX cycle".
This would be best served on the click event of the "save & close" btn of the form. What I dont know is how to accomplish this....
Can I run a query and then if query has any results.....MsgBox?
How about DLookup?
Sorry, I have searched through this forum and the web but found nothing similar....
Thanks