I have a combo box on a form which I want to filter records as the user types. The combo box has two columns ID, Website and I want the WebSite filtered to a value in the DB.
Using VBA I have written:
Me.Form.Filter = "[WebSite] Like '*" & _
Replace(Me.cboFilter.Text, "'", """) & "*'"
but get a syntax error when I compile it. Not sure why.