P
pipeline
Guest
I am relatively new to Access (and VBA). I have built an application complete with a series of nested switchboards, to track general Project Information, Notes, Issues, Deliverable Information, etc. For my deliverable information, I use a form that is bound(?) to a query to display the information for a project. The query asks for the project number and then the results are displayed on the form. So far so good. Very often in the inital stages of a project, there are no deliverables in preparation (e.g. data gathering phase, etc.) Right now, when I query a project's deliverables, and none exist, I get a blank form returned. What I would like to be able to do is, if there are no deliverables for a project, I would like to have a message box returned with the Message "No deliverables exist for this project.", rather than have the blank form displayed on the screen. Clicking on (OKAY) on the message box would return to the previous menu. I am hoping this is relatively simple to do. Any help, insight on how to make this happen would be greatly appreciated. Thanks.