Help with Recordset**RESOLVED**

[JFK]

Hi

Using DAO on a Access97 Database I'm using the following statement to open a recordset.

Set RstCust = Dbs2.OpenRecordset("select * from [sales orders] where customerid = '" & RstEnq![CustID] & "'")

It gives me the runtime error 3021 no current record surely I can select a recordset theat has no records then test for records afterwards. I need to cycle through a list of customers and update there records, there maybe records to update and there may not be but I thought I could open the recordset then check for EF and BOF afterwards. Can anyone see anything wrong with my statement because I can't and I have a very similar recordset statement earlier in the procedure and it works fine

TIA

JFK

[Pasvorto]

Somwhow, it seems to me that you are missing a quote at the end of the SQL statement.

[Ephesians]

You generally get that error when there are no records in the table at all. The index for the table hasn't been initialized in that case.

[JFK]

Ephisians there are over 20000 records in the table, just maybe none that the recordset could return.

Pasvorto which quote and where?

thanks

JFK

[Ecniv]

Originally posted by JFK

Set RstCust = Dbs2.OpenRecordset("select * from [sales orders] where customerid = '" & RstEnq("CustID") & "'")

Customer id is text ??
If so then that should work fine.
You just need to check the EOF property of the recordset afterwards. If its not true, do the processing...


Vince

[JFK]

Ecniv

Customer id is text but I still get the error message, I don't understand why as usually I get the chance to check BOF and EOF but when I run this it stops at the line setting the recordset.

I checked that the database that the table is in is being opened and it is (I assume it is as the .ldb file is created when I use the open database method) so getting a bit frustrated now.

thanks

JFK

[Ecniv]

The rstEnq("custid") is not on a record then.

Do you check that there is a record there first??


Vince

[JFK]

Thanks ecniv although I did check that Rstenq had records I hadn't checked that it had gone EOf from previous operations.

many thanks

JFK