Querying a Filtered Form

[katoc]

Hello.

I have a form. It has a number of fields in it all bound to a table. I have placed an 'Apply Filter' button it, so depending on which field the cursor is at, it'll filter the dataset by that value. Say the form starts out displaying 100 records and I click on the 'Apply Filter' button on 'field1', so now, I have 45 records showing. Is there a way to write a SQL statement where it queries only the 45 records and not all 100?

Thanks.

Sofia

 

[gol4]

could use sql but easiest way would be append the filter
me.filter = me.filter & the new filter

 

[katoc]

Thanks, this helps some. I wasn't aware of this property.