As a beginner Access user I have a couple of problems.
1) When I run a Parameter Query and it has no match in the data base, I am presented with a blank screen. Is there any way that I can make Access return a ‘ default’ screen saying something like “ No Matches Found”?

2) When I press a Cancel button at any point in Access it returns me to the Design mode. Is there any way I can have it returning to one of the forms I have created?

Any help you can offer is very much appreciated.
Many thanks in advance. Andy.