I assume your question refer to the query and not to the form
Create a form with the field you want to fill, that will be the filter for
the query.
Use that example for the query
Select * From TableName Where
Field1 = Forms![FormName]![Field1Name] And
Field2 = Forms![FormName]![Field2Name]
=========================================
If you want all the records to be displayed if you didnt select any value in
the text boxes
Select * From TableName Where
Field1 Like iif(Forms![FormName]![Field1Name] is null or
Forms![FormName]![Field1Name] = "" , "*",Forms![FormName]![Field1Name]) And
Field2 Like iif(Forms![FormName]![Field2Name] is null or
Forms![FormName]![Field2Name] = "", "*",Forms![FormName]![Field2Name])
--
If I answered your question, please mark it as an answer. That way, it will
stay saved for a longer time, so other can benifit from it.
Good luck
RTimberlake said:
I need to have a form that will fill the criteria in a query. I need to be
able to choose Name, Month, and Year on a form and have the query run based
on the selections. Thank you for your help.
