Form Filter Property

[esskaykay]

Hello,

I have a frmGrades based on a query that displays all records. I want to add a command button to the form that when clicked filters the data to a set criteria – something like

Me.Filter = “[ReceivedBy] = ‘SKK’”

I tried coding the forms OnOpen with
Me.Form.OnFilter = False
then coding the command button and that worked. However, that caused a different problem.

Am I close or way off base?

Thanks,
SKK

 

[esskaykay]

Disregard for now - I think I got it. Needs a bit more testing but so far so good.

SKK

 

[boblarson]

Just as an FYI but you would need to turn on the filter too:

Me.Filter = “[ReceivedBy] = ‘SKK’”
Me.FilterOn = True

 

[esskaykay]

I just noticed that.

Thank you,
SKK