Filter on Form

[Guest]

Hello,

I have a combo box "cmbFilterMgr" on my form that I want to filter by when I
select a name from the list. I have a combo box field on my form which is a
User Name field and is called "LoggedByID". In my filtering combo box I want
to select a User name and have my form be filtered to only show records with
that User name.

The code I'm using does nothing. It is:

Me.Filter = "LoggedByID" = Me!cmbFilterMgr
Me.FilterOn = True
DoCmd.Requery
End Sub

Thanks,
Janet

 

[Guest]

My code is on the AfterUpdate event of the filtering combo box.

Janet