Criteria Query

[TomBP]

I have a number of filters across the top (6 in total). I want to run any number of these filters and then only print the relevant records that pop-up after I pressed the search button. As you can see now I have searched for records that contain TSA. It shows 3 records from a total of 16.

I had the following in mind but haven't got the knowledge to make it happen:

I need to build a query that picks up the criteria from the form. Then Build a report that is based on this query. So that the query only shows the records that are shown in the subform.

Someone already tried to help me and suggested that I filled in the following in my query:

Forms.[MyForm].[MyField] Or Like Forms.[MyForm].[MyField] Is Null

But my experience of such criteria is'nt all that so I don't know how to typ this so that it matches my database.

My subform = frmSubform
My mainform where the subform is located = frmSearch

I also uploaded my database to yourfilelink.com . If you want to have a look. It's only 200kb.

http://www.yourfilelink.com/get.php?fid=141709

 

[MStef]

Hello TomBP!

Look at "DemoMultiSearchA2000.mdb", I think it can help you.

 

[TomBP]

I have taken a look at that database but it's not what I'm looking for. Thanks for your reply tho.

 

[EMP]

See the Basic Criteria Format in Jon K's sample database:
http://www.access-programmers.co.uk/forums/showthread.php?t=103312

^