Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2014
    Posts
    46

    Unanswered: Delete records, recordset not working?

    Kind of slow around here so I thought I'd keep asking about some problems I'm experiencing. I define a recordset based on a query. My next statement is "Delete Records", Recordset variable (that was defined above). However, the statement does not execute. Interestingly, if I use "Move Records" to Recycle Bin, Recordset variable, it executes properly! Anyone else experience this? Any thoughts? Thanks.
    Don

  2. #2
    Join Date
    Jul 2012
    Location
    Ireland
    Posts
    815
    Provided Answers: 17
    You don't have to get the query to define the recordset in order to identify which records are to be deleted.

    The actual delete function can run the query directly and it will work directly with the results the query returns.

    Regards
    James

Posting Permissions

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