query input

[exc]

i am new to access so please be patient!

i have set up a query with criteria so that the user enters the desired data (zip code for example) and brings up the appropriate information.

is there a way to set up the criteria so instead of a text box prompting the user there is a combo box?

i wish my end result to be a report generated from user input. the user input would come from text boxes populated with data from the tables. i do this all the time in asp pages but need to now do it in access.

thanks in advance

eric
eciminski@graham.az.gov

 

[JoeMiller]

In the query that feeds your form set the criteria to reference the controls on your form. Then the query will be restricted to what's in the form. To reference a control on a form in query criteria use this syntax:

Forms!MyFormName!MyControlName

Simple is, as simple does!

Joe Miller
joe.miller@flotech.net

 

[exc]

thanks...that did the trick. now i gone hog wild on these reports generated via queries. lots more work to do now...on second thought...do i really want to know this stuff! 8)