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.