Access record empty and subform help

I have a form that is run on a query. A date is entered on the opening of the form and any meetings on that date appear on the form. However, when a date is entered that there are no meetings on I want a message box to appear saying that a meeting on that date doesn't exist and the form wont open if you click OK, but will if you click cancel.

Also, is it possible to just click on a record in a subform and have that record appear in a new form, instead of having to run a seperate query and enter the details manually?

Thanks in advance

For both questions you need to make some changes to your code to get the program to work the way you want. Look at the code around the dialog box that pops up to solve the first.