Hi!!

I'm really stuck on this and have been for awhile. I'm hoping to get some help!

I have tired all of the below and got the following error.

"SELECT * FROM Customers WHERE ProductID = " & (Text6.Text) & ";"

Error: Failed getting rowsets from current data source.

"SELECT * FROM Customers WHERE ProductID = " & CLONG(Text6.Text) & ";"
Error: Failed getting rowsets from current data source.


"SELECT * FROM Customers Where ProductID = " & Val(Text6.Text)
Error: Failed getting rowsets from current data source.

What is wrong?? How do I fix it?

I produce a datareport but the sql statement isn't working for displaying only 1 customer. I would like to display the information for one customer. The field that the one customer is based upon is a number which is entered into a text6.text box on a previous form.

Customers is a table name. ProductID is a field in the table. Do I have to say the what form it comes from???

Thanks