Applyfilter [wherecondition]

  • Thread starter Thread starter Paul
  • Start date Start date
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
 
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
 
Back
Top