Apply filter to form when form open ?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a form that displays a single record (Filter always specifies a key).
In some cases while the form is open I need to position to a different
record. How do I do this? I tried setting Me.filter and doing me.refresh
and/or me.requery but it does not work. Anyone know how to do this?
 
mscertified said:
I have a form that displays a single record (Filter always specifies a key).
In some cases while the form is open I need to position to a different
record. How do I do this? I tried setting Me.filter and doing me.refresh
and/or me.requery but it does not work. Anyone know how to do this?
Click to expand...

Me.Filter = "New Filter String"
Me.FilterOn = True
 
Back
Top