Parameter field problem in query menu

[PaulA]

I'm using A2007. I created a menu form to generate multiple queries that includes start date and end date parameter fields.

Twice now, I have found that when running a query from the menu, I get a pop-up window as if no dates had been entered in the parameter fields, even though they had been. I can't correct this without deleting the parameter fields and recreating them.

Since this has happened twice withing the past week, I'm thinking that this will be an ongoing problem, but I have no idea what is causing it, since the menu form does work initially.

Any ideas? It's quite irritating!

Thanks.

Paul

 

[vbaInet]

Keep the form open when throught the session of the query.

 

[PaulA]

Thanks for your post, although I'm not sure what you mean. I found, though, that if upon opening the form, I have an event that clears the fields (txtField = ""), the problem seems to be solved.

Thanks.

 

[vbaInet]

The query is a parameterised query that gets one its criteria from a form right?

 

[PaulA]

Yes--the form is a series of buttons that open queries that utilize one or both of the form parameter fields.

 

[vbaInet]

The only two scenarios when a (simple) Select query will prompt for a value that points to a field are:

1. The query was open before the form
2. The form was closed while the query was running

It was point number 2 I was referring to.