Form filters (1 Viewer)

[Lanason]

I have a combo box on a form header to select a persons name to filter the data below

but cant get the syntax correct - the combo box name is OwnerFilter

Me.Filter = "Owner = OwnerFilter"
Me.FilterOn = True

this doesn't work - any help please

 

[Ranman256]

Are you looking up the name or the ID (string or number)
Strings need quotes....

Me.Filter ="[owner]='" & cboBox & "'"

 

[Lanason]

That was so obvious when you posted it - thanks #BrainFade