A quick question

[DeanH]

I have a database which stores visitor information. I would like to set up a query so that a user can click the query, input a country name and then be shown the visitors from that country.

At the moment i can only enter criteria such as '=England' into the criteria box which is ok but what happens if the user wishes to look up visitors from Germany. I dont want to have to create a different query for every country in the EU

How do i bring up the enter parameter box so that the user can type which country He/She wants to view?

Thanks in Advance.

 

[indyaries]

Dean,

I'll presume that you have a field called Country.

In the Criteria line of your query, enter this:

[Enter Country]

This will open a small entry box for the user to input the country of their choice. This will return all countries that equal the name the user input.

HTH

Bob in Indy

 

[DeanH]

Thanks a lot