Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2005

    Unanswered: Copying a record to another table

    I'm new to databases, but what I'm trying to do is to make a button on a form that will move the current record to another table and delete it from the original table. I know this probably isn't something that is usually done, but is there a way to do it?



  2. #2
    Join Date
    Dec 2004
    use the append query and delete query. in the criteria make sure its set to the field on the form where the command button will be

Posting Permissions

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