Applyfilter [wherecondition]

P

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
 
A

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
 
Top