My query runs BEFORE my startup form appears.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have created a query that asks the user for input. I have created a form
with a checkbox that, when checked, will run the query. But the query jumps
the gun. It runs first, asking the question; then the form appears with the
checkbox which, when checked, runs the query again. Naturally, I want the
form to appear as soon as the database is opened. Can this be fixed? How?
 
Which event are you having it run the query? It should be the onclick
event?

Make sure you dont have the query running on any another events =)
 
I'm still having trouble with this. I'm afraid my expertise doesn't extend
to "on click" except when I work in MS Word. I went into form design and
double-clicked on my checkbox; the properties options offered did not include
an "event". I also created a macro with the only line in it being
"OpenForm"; I even called it AutoExec. Still no luck. I'm getting really
frustrated with this.
 
Back
Top