Simple filter problem

[dominicg123]

I have a combo box name FtlUser. I want to apply a filter with that combo box but I get a dialog box asking me for a parameter. Probably a simple mistake....

Private Sub FtlUser_AfterUpdate()

Me.Form.Filter = "[ActionFor]=" & Me!FtlUser

Me.FilterOn = True

End Sub

 

[TheAceMan1]

How are ya dominicg123 . . .

Perhaps your not selecting the right column! Use . . .

[blue]   Me.Form.Filter = "[ActionFor]=" & Me!FtlUser.Column([purple][b][i]x[/i][/b][/purple])[/blue]

Make note: [blue]Column Index[/blue] starts at zero and includes any fields set to zero (0) in the [blue]Column Widths[/blue] property . . .

See Ya! . . . . . .

Be sure to see FAQ219-2884:

 

[dominicg123]

I only have one column to my combo box. I did add what you said but I still get this stupid parameter box with the title being the record that I choose in my combo box:

Private Sub FtlUser_AfterUpdate()
Dim cuser As String

cuser = Me.FtlUser.Column(0)
MsgBox cuser

Me.Form.Filter = "[ActionFor]=" & cuser
Me.FilterOn = True

End Sub

 

[PHV]

What about this ?

Me.Form.Filter = "ActionFor=[!]'[/!]" & Me!FtlUser [!]& "'"[/!]

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886