Shouldn't be this hard - Filter using combo box 1

[adamr99]

I am having trouble using the DoCmd.ApplyFilter command.

I want it to get the filter criteria from a combo box. The code I am currently using is as follows:

DoCmd.ApplyFilter , "[Contact_Title] Like 'Combo8.Text' & '*'"

I have tried every variation of the above. [Contact_Title] is the feild that I want to filter by, and Combo8 is the combo box that has the text that I want to filter by. I know that this is really easy, however it is giving me fits this morning.

Thanks!
Adam

 

[Aivars]

...Like '" & Combo8.column(0) & "'*"
column(0) - first column
column(1) - second column
etc.

Aivars

 

[TheClaw]

Try this.....

DoCmd.ApplyFilter , "[Contact_Title] Like '" & Me![Combo8.Text] & "'"