Filtering

[dplotts]

On a form I have it setup to filter with a combo box for either project name or project number. The code coresponding to this is:

Project Number:

Private Sub Combo159_AfterUpdate()
DoCmd.ApplyFilter , "ProjectNumber=" & Me.Combo159
End Sub

Project Name:

Private Sub Combo288_AfterUpdate()
DoCmd.ApplyFilter , "ProjectNumber=" & Me.Combo288
End Sub

I use this same exact code on another form and it works fine. When I try to filter using the project name box, I get a run tim error 3075, Missing operator.

Both combo boxes are unbound and have the correct source (projectname or project number)

Does anyone have any idea what the problem could be?

 

[TonyJollans]

Hi dplotts,

Unless your Project Name is numeric, it needs to be in quotes.

DoCmd.ApplyFilter , "ProjectNumber=

'

" & Me.Combo288

 & "'"

Enjoy,
Tony

------------------------------------------------------------------------------------------------------
We want to help you; help us to do it by reading FAQ222-2244 before you ask a question.