tommyellis
03-15-2001, 12:32 AM
I want to use a form to enter criteria (Text) into a querry and then return the contents to a report.
|
View Full Version : Use a form to enter report criteria tommyellis 03-15-2001, 12:32 AM I want to use a form to enter criteria (Text) into a querry and then return the contents to a report. Rich@ITTC 03-15-2001, 04:22 AM Hi TommyEllis In your query you need to reference the text box on the form within the criteria row of the query. So, if you are looking for people with the last name of "Smith" you would add in the column/field LastName of the query the following in the crieria. Forms!frmMyform!txtMytextbox (obviously frmMyform is replaced by the name of your form and txtMytextbox is replaced by the name you give to the text box on that form where you or your user will input the data). You can also use combo boxes or list boxes (or any other control type - Option Groups etc) as the criteria to run a query. HTH Rich [This message has been edited by Rich@ITTC (edited 03-15-2001).] tommyellis 03-15-2001, 05:31 AM Rich@ITTC Thanx a MIL it worked perfectly Tommy |