cbo Lookup Error

What changes do I need to make to the following to allow lookup of office
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/14032-cbo-lookup-error.html
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
--
Jeff C
Live Well .. Be Happy In All You Do
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=14032

*

 
Do share your immediate thoughts or reactions on this issue? We value your views! Login Now! or Sign Up Today! to share your views with us.. Gurfateh!

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

For an explanation, see:
Quotation marks within quotes
at:
http://allenbrowne.com/casu-17.html
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=14032

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Jeff C" wrote in message
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=14032
news:ABE3CD7B-3C43-4E96-B6E1-01EAE862BC2D@microsoft.com...
> 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
> --
> Jeff C
> Live Well .. Be Happy In All You Do

"Jeff C" wrote in message
:
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=14032
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=14032
> 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?

--
Roy-Vidar

Thanks Allen I printed up your tutorial too.

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


"Allen Browne" wrote:

> 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.
> Tips for Access users - http://allenbrowne.com/tips.html
> Reply to group, rather than allenbrowne at mvps dot org.
>
> "Jeff C" wrote in message
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=14032
> news:ABE3CD7B-3C43-4E96-B6E1-01EAE862BC2D@microsoft.com...
> > What changes do I need to make to the following to allow lookup of office
> > names that include apostrophies?
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=14032
> >
> > 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
> > --
> > Jeff C
> > Live Well .. Be Happy In All You Do
>
>
>