Applyfilter [wherecondition]

[Paul]

Hello Gurus and newsgroup users.

Your kind help please.

I want to filter a continuos form using a combobox. I am
using the afterupdate event of the combo and Applyfilter.
Could anyone explain to me or give me an example of
the “where” condition.

Many thanks

Paul

 

[Albert D. Kallal]

Assuming that the combo box returns a city field, you could in the after
update event of the combo box go:


me.Filter = "City = '" & me.myCombo & "'"
me.FilterOn = true