Thread: Filter Question
View Single Post
  #1  
Old April 20th, 2010, 03:23 PM posted to microsoft.public.access.forms
hotplate
external usenet poster
 
Posts: 55
Default Filter Question

I have a combo box with all the employee names. A name is selected
and a filter is applied to the form as follows:

DoCmd.ApplyFilter , "[employeename]='" & Me.Employee & "'"

The problem I am having are that 2 of the employees have a ' in their
name, like O'Conner.

This causes an error. Is there any way I can handle this?