Is there a way to do a query by filling in a from?

[newtoAccess]

Is there a way to do a query by filling in a from?

[kumar.dkr]

Just you try it with update query, this will work

Regards,
Kumar.

[newtoAccess]

I want to just find data from a from and then send it to a report.
Should I use select query, make a form that points to the query?
On the form have a button that runs a macro to run the query then go to a report?
Is that how I should proceed?

[newtoAccess]

OK I have a form.
I have a query that will find multi pule entries that is on the forum.
However if one of the fields is blank on the forum then there is no result.
How do I set it up where the user can fill in one field or several fields on the forum to get a result?

[Xiaoding]

Try setting the default values of the form text boxes, to zero, or something that won't mess up the query. You can do that in the properites of the text boxes.

Otherwise, dealing with blank boxes takes some VBA, I think.

[newtoAccess]

Found it but everything I used gave me a null noting found response.

[newtoAccess]

Are there any wild cards I can use as default to find everything if field not filled in?