Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2004
    Cary, NC

    Question Unanswered: Preview Action Query

    Is there a way to allow a user to preview the records affected by an action query through code?

    The query is ran with a command button and a docmd.openquery statement. I want to provide them with the option of viewing the records that the query will delete and be able to choose if they still want to run the query.

    The result I am looking for is the same as if you were in design view and pressed datasheet view, the records would be displayed but no action would be taken.

    Any thoughts?


  2. #2
    Join Date
    Feb 2004
    Chicago, IL
    Have a second query that is a Select query. Display the records that will be changed and then run your action query.

Posting Permissions

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