Hey guys...This is ridiculous. I'm trying to put quotes in a string. What I have been doing is:

strQuery = "select * from tblCustomers where tblCustomer.Cust_Id = \"" & text1(2) & "\""

Is this correct? I thought you used \". However.... I tried this to find out.

strQuery = "select * from tblCustomers where tblCustomer.Cust_Id = \"" & text1(2)

I hit enter to finish the line and it gave me:

strQuery = "select * from tblCustomers where tblCustomer.Cust_Id = \"" & text1(2)"

The strQuery is defined and all of that. I've tried hardcoding the above query (with the " " around the correct value) into the control and it works fine. Thanks a lot!!

-=-Neal Alvey



------------------
...NeAlvey, the world's best Sim Farm player EVER...and you should know that!