cbo Lookup Error

[Guest]

What changes do I need to make to the following to allow lookup of office
names that include apostrophies?

rs.FindFirst "[Office_Name] = '" & Me![cbo_Office] & "'"


These kind of syntax errors just drive me NUTS, someday I will understand
the rules.

Thank you in advance

 

[RoyVidar]

What changes do I need to make to the following to allow lookup of
office names that include apostrophies?

rs.FindFirst "[Office_Name] = '" & Me![cbo_Office] & "'"


These kind of syntax errors just drive me NUTS, someday I will
understand the rules.

Thank you in advance

You can do what is often called "doublequoting"

rs.FindFirst "[Office_Name] = """ & Me![cbo_Office] & """"

but - when doing lookups like this, don't you have a primary key field
within the combo you could use?

 

[Allen Browne]

Try:
rs.FindFirst "[Office_Name] = """ & Me![cbo_Office] & """"

For an explanation, see:
Quotation marks within quotes
at:
http://allenbrowne.com/casu-17.html

 

[Guest]

Thanks Allen I printed up your tutorial too.

Thanks to you too Roy
--
Jeff C
Live Well .. Be Happy In All You Do

Try:
rs.FindFirst "[Office_Name] = """ & Me![cbo_Office] & """"

For an explanation, see:
Quotation marks within quotes
at:
http://allenbrowne.com/casu-17.html

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

What changes do I need to make to the following to allow lookup of office
names that include apostrophies?

rs.FindFirst "[Office_Name] = '" & Me![cbo_Office] & "'"


These kind of syntax errors just drive me NUTS, someday I will understand
the rules.

Thank you in advance