Filter by Form Special Cases? 1

[MontgomeryPete]

We are filtering by form to obtain information from a table in order to correct it. This works fine until names with apostrophes are entered such as O'Donell and O'Brien. The filter by form retrieves them from the table, but not from the form. The form returns a blank record. All other filter requests function OK.

Any thoughts?

 

[HandsOnAccess]

If is possible to fix the issue,
Kindly post the form filter condition.

Regards

 

[MontgomeryPete]

Thanks for responding. I solved the problem by building a combo box and allowing the user to select the appropriate name. All names do actually appear in this box. I then use a subform to enable the user to edit the record.

I understand from others locally that trying to retrieve special charaters with filter by form is a common problem.

Thanks again, Hands On Access.

 

[HandsOnAccess]

To overcome such problem just use the following syntax

"CustomerName = """ & me.CustomerName & """"

Or you can also use this type

"CustomerName = [Forms]!<<Form Name>>.CustomerName"

Regards

 

[MontgomeryPete]

Thanks, the second format did the trick.
Pete