Hello all,

I think I am running into trouble here with my Unique_IDs. They are
generated by a 3rd party application and I pull them down monthly for sales
reports, etc. I've listed a few below:

5 A!\]\
Y .1^S]
"T\" _!'&_

My combo boxes and listboxes always seem to blow up on records that have a
single quote ' in their Unique_ID. I get the message: Runtime error
'3077': Syntax error in expression.

If I select records that don't have a single quote in the Unique_ID field,
they populate the form.

I can't change the format or makeup of the Unique_ID's as I am pulling them
from a 3rd party app. But, can I change them somehow on import? Or wrap
them in something so the "Findfirst" statements don't crash?

TIA,

Jake


"GitarJake" wrote in message
news:%3jjc.424$NZ4.319@lakeread05...
Can someone tell me what's wrong with this statement? I keep getting a
syntax error when I try to add a combo box to this form.

SELECT DISTINCTROW Contacts.UNIQUE_ID, Users.Name AS NovoName,
Contacts.Company, Contacts.Contact, Contacts.IDStatus, Contacts.[Create
Timestamp] AS CreateDate, Contacts.Phone, Contacts.[Web Site],
Contacts.Industry, Contacts.[Address 1], Contacts.City, Contacts.State,
Contacts.Zip, Contacts.Country
FROM (Contacts INNER JOIN Sales ON Contacts.UNIQUE_ID = Sales.Contact)
INNER
JOIN Users ON Sales.[Record Manager] = Users.UNIQUE_ID
WHERE (((Contacts.IDStatus) Like "*customer*"))
ORDER BY Contacts.Company;

Thanks,

Jake