another stooopid question from a numpty!

[philwalker531]

hi

i have a database that i would like to be able to search to return entries between two dates and filtered by specific person. each person has a unique number.

i have done a basic query that has a pop up asking for the required dates - how do i get it to pop up to ask for the persons number?

cheers i know this should be relatively straight forward but ive failed spectacularly so far!

 

[John Big Booty]

You could have a pop up form that has two unbound text boxes to allow to and from date entry, and an unbound combo box that contains all the possible names.

You could use a calendar control to simplify date entry.

You would have a button on this form that would first check that all fields held valid data, and then opened a further form populated by your query.

The query would use criteria like;

Forms!YourPopUpFormName!CotrolName

For the To, From dates and Person's ID number.