Results 1 to 8 of 8

Thread: Help with Recordset**RESOLVED**

Threaded View

  1. Jun 2nd, 2003, 08:12 AM #1
    JFK
    JFK is offline

    Thread Starter
    Lively Member
    Join Date
    Oct 2002
    Posts
    112

    Help with Recordset**RESOLVED**

    Hi

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

    Code:
    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
    Last edited by JFK; Jun 5th, 2003 at 04:35 AM.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width