Query Pop ups

[pwoodj]

Quick Question:

I am developing a query and I want to have the user input a value (ie criteria).

How do I do this?

Basically, when the query is run, small windows pops up and ask you to enter a value.

I've seen it before, I can't recall how it works..

And help would be great..

thanks,
pete

 

[mkelly]

In yoou query under "Criteria"
say you want records for a specific employee number.

put

[Enter Your Employee Number]

then when you run the query or report a pop up will appear saying "enter your Employee number" and only those records will pull from the query.

 

[pwoodj]

thanks alot

 

[Mile-O]

Of course, this isn't the most robust method as you can't evaluate the query (if it has records or not) or ensure that the parameter entered meets the format you'd expect. i.e. I could ask for a date and the user could enter rjjsfklsd without the query flinching.

Using forms is the preferred method. Rather than [Enter Value] we can put [Forms]![FormName]![TextBoxName] into a query and it would refer to the textbox on a form to get the parameter it needs.