The information in this article applies to:
Moderate: Requires basic macro, coding, and interoperability skills. SYMPTOMS
When you use the FindFirst method, you receive a No match or a run-time error message.
rst.FindFirst "[CompanyName] = 'B's Beverages'"This behavior also occurs if you use the FindFirst method in the AfterUpdate event procedure of a combo box, and you search for a value that contains an apostrophe. For example: Me.RecordsetClone.FindFirst "[CompanyName] = " & Me![ComboboxNN] CAUSESearches for text strings that contain quotation marks (") or apostrophes (') require special syntax because both characters are used as delimiters in Visual Basic for Applications. RESOLUTIONWorkaround for Using a Text StringWhen you are typing your search argument, use double quotation marks in your search string to find values that contain single quotation marks and use single quotation marks in your search string to find values that contain quotation marks. For example, to search for a CompanyName that includes an apostrophe, replace the single quotation marks around the CompanyName value with two sets of double quotation marks, as in the following example:rst.FindFirst "[CompanyName] = ""B's Beverages""" Workaround for Using a Combo BoxIf you are using a combo box to find values that contain quotation marks or apostrophes, add the primary key to the combo box and make it the bound column. Hide the bound column. Then change your criteria so that it searches in the field that corresponds to the bound column in the combo box.MORE INFORMATIONSteps to Reproduce Behavior
rst.FindFirst "[CompanyName] = ""B's Beverages""" REFERENCESAdditional query words:
Keywords : kbdta GnlFnd |
Last Reviewed: May 13, 1999 © 2000 Microsoft Corporation. All rights reserved. Terms of Use. |