My query runs BEFORE my startup form appears.

D

Donnithorn

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?
 
L

Little

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 =)
 
D

Donnithorn

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.
 
Top