Very Computer

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.

The Rorynater
Rory Latham

What I see is that you have a field with a space in it, you should use a
pair of [ ] around Credit Limit, in the actual case it should be: [Credit
Limit]

bye, Thomas

Rorynater schrieb in Nachricht

This is how your query should look

Set rstSQLRecord = dbsData.OpenRecordset("Select Credit Limit from
CustomerInfo WHERE Customer!CustId = CustomerInfo!CustomerId and
Customer!CustomerName ' = " & list1.text & " ' ")

Well  both of you are close

Set rstSQLRecord = dbsData.OpenRecordset("SELECT [Credit Limit] from
CustomerInfo WHERE Customer!CustId = CustomerInfo!CustomerId and
Customer!CustomerName  = '" & list1.text & "' ")

                                                    ^
^
                                                <sq><dq>
<dq><sq><dq>

Gotta watch those spaces and quotes.

I would also suggest if at all possible not to use database field name with
spaces... makes you job a whole lot harder.