Combo box doesn't want to search last name with apostrophe

[Nika]

I have problems with my combo box that I have created in Access 2007 by using
wizard. It doesn't want to find last names with apostrophe such as O’Neil.
Can anybody help me please?
I would greatly appreciate it.
Thank you.

 

[Cheese_whiz]

Hi Nika,

Most likely it's because the code in the combo boxes after update event uses
a combination of single and double quotation marks, when it's better to use
just the double quotation marks.

If that's the case, replace each single quotation mark with two of the
double quotation marks and it should work.

HTH,
CW

 

[Nika]

Thank you. I don't see any code. This is what I have under codes:

Private Sub Combo578_AfterUpdate()

End Sub

That is all.
I don't even know how to start writing a code.
Any suggestions?
Thansk again for your help.

 

[Cheese_whiz]

Hi Nika,

Unfortunately, I jumped on your question before checking to see if '07 was
any different with respect to combo box wizard, and it is. I use mostly '03
but I have a copy of '07 on a notebook and it appears that if you run the
control wizard for a combo box like you want you get an embedded macro to
power it. That means that you wouldn't have any vba code tied to that event.

Can you provide the rowsource of the combo box you're working on? It's on
the data tab of the properties window.

Thanks,
CW