Restrict query running

  • Thread starter Thread starter Rob
  • Start date Start date
R

Rob

Hi,

Is it possible to stop a query being run other than being run via a button
on a form. I have a query that only returns the correct result if certain
dates are entered via a form.

Thanks, Rob
 
You'd have to write code that would "stop" the attempt to run a query if all
data required by it are not entered. Your users shouldn't have access to the
queries directly anyway, so your form should be the only way they run that
query.
 
Back
Top