Kodo step in :)

Code:

SELECT CUST.ST_CD, CUST.FNAME, CUST.LNAME, CUST.CITY, CUST.CITY, CUST.ZIP_CD, CUST.ADDR1, CUST.ADDR2 FROM CUST WHERE CUST.CITY='" & Text1.Text & "'"

Ok ive tried this with and without a semicolon and I keep getting error that SQL statement is not properly ended.


AHHHH what am I doing wrong here. I could have sworn this worked before.

 

I fixed the double city selection. Still error

oRs.Open sql, oCn, adOpenForwardOnly, adLockReadOnly

thats my connection.

 

you put the semi colon after the '"&text.text1&"' ; " like that?
otherwise,I don't see any problems

 

yeah this is bad. I don't understand why im getting that message.

 

Try breaking it down.. do one field selection at a time until it breaks.

also , you might find this interesting.
http://www.4guysfromrolla.com/webtech/092599-1.shtml