I have the following Querry in code:
Set rstSQLRecord = dbsData.OpenRecordset("Select Credit Limit from _
CustomerInfo WHERE Customer!CustId = CustomerInfo!CustomerId and _
Customer!CustomerName = list1.text ")
Every time I run the above code, I get the error
Run-Time error '3075'
Syntax error (missing operator) in querry expression 'Credit Limit'.
I can not figure out how to make this work. Any Suggestions would be greatly
Thank you for any help you can give.