Open form from an empty query

C

CP

If a query produces 0 entries is there a way to open a specified form

For instance if my queries searches for a client and does not find them it
will force the "enter new client" form to open?
 
A

Allen Browne

No. Queries are not powerful enough to do that.

Use a form - in Datasheet view if you want it to look like a query.

You can add code the the Open event procedure to cancel this form if it has
no records, and open another instead.

(You will need some experience with VBA code to achieve that.)
 
Top