Access 2010
I am using Access 2010 with VBA. I have a simple form that uses a query (based on a table) as the record source. Using VBA, how can I determine if the query successfully found records? How many records? I would like to use the form's Open_Event to determine if the query was successful and there are records available for the form to process. If not, I will display a message indicating no records were found and CANCEL=TRUE and exit the OPEN_EVENT.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
> .. it was easier for me to implement.
? - so four lines of code is hard?
You should always go for the fastest working method.
/gustav
? - so four lines of code is hard?
You should always go for the fastest working method.
/gustav
ASKER
Both answers give me a solution. I liked MicroShadow's answer a little better because it was easier for me to implement.
SowleMan