what Me.filter does on Access (form.filter)

[MUKESHY12390]

Hi All,

I'm trying to figure out what me.filter does on from. In other when we see "Form on design mode", ===> property sheet ===> Filter.

I'm sure it would simple question for those who familiar with Access.

any help would be appreciate.

Thanks,
Mukesh Y

 

[alansidman]

https://msdn.microsoft.com/en-us/library/office/ff194672.aspx

 

[MUKESHY12390]

thanks for reply. I really didn't understand exactly, could give me your own couple of line which explain entire concept.

I'm still confuse a bit.

 

[xenou]

Hi,
a form filter works just like a where clause in a query.

Example, if you query has "WHERE [Price] > 50.00" this limits results to records with price Greater than 50. So a form filter does the same thing - you would (or could) put a similar criteria in at the form level, to limit results. I don't know if I could give you a specific reason why to do this in a form or not, but in a form-driven application you might have a base query that is then passed to a middle layer or a client layer that applices filtering logic.