Please HELP!

I have a single table with ac_type, ac_registry, maint_type, date_performed, location and remarks fields. I am trying to create a form that lets me fill in either one or all of the parameters and then a report will display those matching my criteria. I tried following some steps stated in this forum but to no avail. Hope you can help me.

Thank you so much!

Regards,
Tet

See this thread that is going on right now and then post if you have additional questions: http://p2p.wrox.com/topic.asp?TOPIC_ID=66089


mmcdonal

Look it up at: http://wrox.books24x7.com

Thanks for the link, mmcdonal. However, is there a way to do this on the front end, i mean without having to do the coding?

I don't know what you mean by "do this on the front end". This is front end work. I don't know how you could tell the application to do something without coding. You are going to have to put some code somewhere, otherwise you will only get default behaviors.


mmcdonal

Look it up at: http://wrox.books24x7.com

To search for multiple criteria using a form, you can create a query and in the criteria field for the query use, Like "*" & [forms]![NameOfForm]![NameOfControlInTheForm] & "*".

I would name the controls in the form like
txtac_type
txtac_registry

and I might name the form frmSearchForm

then the statement in my criteria field would look like
Like "*" & [forms]![frmSearchForm]![txtac_type] & "*"

Thanks mucho! I did it! :D