I am having a little difficulty witht he syntax of a lookup using access DB
here is the code:
"SELECT * FROM tblContacts WHERE ContactID IN (353,1520,2031); Order by ContactID"
It works find without the order and I have tried without the ; or with the ; at the end, but no luck.
Anyone genious enough to know the correct syntax.