D
Don S
Using Access 2007 I have created a combo box using the combo box wizard to
find specific records on a form. The wizard created an embeded macro where
Action: SearchForRecord
Arguments: , , First, ="[Name] = " & "'" & [Screen].[ActiveControl] & "'"
Record: First
Where Condition: ="[Name] = " & "'" & [Screen].[ActiveControl] & "'"
It finds all records as selected except for those which have an " ' " in the
name such as Arby's or Ryan's.
In a previous post I was instructed to replace the single apostrophy (')
with double apostrophy ("). However, doing that resulted in the macro not
working at all.
Again thanks for all your help.
find specific records on a form. The wizard created an embeded macro where
Action: SearchForRecord
Arguments: , , First, ="[Name] = " & "'" & [Screen].[ActiveControl] & "'"
Record: First
Where Condition: ="[Name] = " & "'" & [Screen].[ActiveControl] & "'"
It finds all records as selected except for those which have an " ' " in the
name such as Arby's or Ryan's.
In a previous post I was instructed to replace the single apostrophy (')
with double apostrophy ("). However, doing that resulted in the macro not
working at all.
Again thanks for all your help.