Filter on query

[jbs]

Hi,

I have a query with numbers in one column and check boxes in 3 other columns. basically im after a way to filter the number range between 5 and 10 and then if the checkboxes are checked. I can do this manually but the filter keeps resetting and i was wondering if there was a way to automate this?

Thanks.

 

[MStef]

Look at "DemoFilterQueryA2003.mdb (attachment, zip).
Open Form1 and try.
Adapt it in your mdb.

 

[jbs]

Thanks MStef

I am trying to adapt it to my database, but it just opens up the query and doesn't filter.

I have changed the query name to the query name i have.
Is there an area in the code where i put the column reference or something? (i am a massive novice)

 

[MStef]

Look at "criteria" in query1.