Creating a search form using a query 1

[turtlpc]

I have a query, that searches a table based on the parameters I provide. This was pretty simple using the criteria in the query design (SELECT [File Directory].CDnumber, [File Directory].Doc_Number, [File Directory].Doc_Type, [File Directory].[Document Date], [File Directory].Customer, [File Directory].Amount, [File Directory].CDFilename
FROM [File Directory]
WHERE ((([File Directory].Doc_Number)=[Enter a Document Number :])) OR ((([File Directory].[Document Date])=[Enter a Document Date :])) OR ((([File Directory].Customer)=[Enter a Customer Number :])) OR ((([File Directory].Amount)=[Enter a Amount :]));
).

However, the users would prefer to see all four search parameters presented on the same form and not as per the defaulted four enter parameter windows. I guess I've been looking at it too long and just can't see it. I would appreciate any assistance with this issue, thanks.

 

[EarS]

Simply make a form with the 4 text boxes. in the design view of you query say
= forms!name_of_your_form!name_of_text_box
in the criteria
with this it will pull the data from the form.