Query Help

[janed]

I have a query that looks up a telephone number. i have a pop up where the user enters the required number and then the table with the results opens. this works fine.
however, i have made a second similar query. if i open the query it works fine but if i open the pop up form and do it from there the table of results flashes on so quickly that i cant see it. the only difference is that the field i'm searching is formatted in the table in the second one. would this be anything to do with the problem?

 

[Navyguy]

I am not sure why this would be the case, but it sounds like you have a timer event triggering on the open form event, similar to a splash screen.

Not sure why you would, but perhaps you copied the form from a splash screen and the properties came with it.

Just a thought.

 

[janed]

what would the timer event be on? i copied it fro the first one.

 

[Navyguy]

It would be on the properties box of the form, under the event tab. There are two choices, on timer and timer interval. The on timer should be blank and the timer interval should be 0 (zero).

Make sure your form is in design view and right click on the form and select properties.