Use a form to enter report criteria

[tommyellis]

I want to use a form to enter criteria (Text) into a querry and then return the contents to a report.

 

[Rich@ITTC]

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]

Rich@ITTC

Thanx a MIL it worked perfectly

Tommy