RichO
Registered Yoozer
- Local time
- Today, 14:59
- Joined
- Jan 14, 2004
- Messages
- 1,036
I have been able to find information on this regarding reports but not for forms...
I have a form based on a query. This form is opened from another form with a DoCmd.OpenForm command. If the query returns no data the form opens with an error message.
I would like to have the form not open if the query returns no records but is there an easy way to determine this? I could open the query as a recordset and check for EOF, but is there a better way?
Thanks
I have a form based on a query. This form is opened from another form with a DoCmd.OpenForm command. If the query returns no data the form opens with an error message.
I would like to have the form not open if the query returns no records but is there an easy way to determine this? I could open the query as a recordset and check for EOF, but is there a better way?
Thanks