Results 1 to 4 of 4
  1. #1
    Join Date
    Aug 2005
    New England

    Question Unanswered: Appending Record

    How would I go about setting up code to add a record from one table to another table? I have a form that is used to enter in scores for different tasks, some of those tasks need to be tracked daily. I have another table for only those tasks which are scored daily. I also have a yes/no field to indicate which tasks should be added to the daily table. Is there a way to add those tasks with a "yes" check to the daily scores table, without having to open the daily scores form? I'm sure there is, I just can't think of what it is.

  2. #2
    Join Date
    Nov 2003
    See the SQL Insert Into statement. This is a quick way to add a specific record to a table..
    Self Taught In ALL Environments.....And It Shows!

  3. #3
    Join Date
    Oct 2005
    DoCmd.RunSQL "INSERT INTO tablename SELECT fieldname(s) FROM tablename"

    If you want to set conditions, you can also use the WHERE clause, in your case WHERE [Field]=Y.

    Hope this helps!


  4. #4
    Join Date
    Jun 2005
    I have a question similar to this.

    I have a Select query that list records based on the criteria [Enter ItemID]. I created a form using this query. When the form opens it prompts the user for to enter ItemID. What I want to do is to insert a code in the "On Change" procedure of the ItemID field in the Form. When the user change any character on the ItemID. The code should create a copy of the updated record and put it on a different table. How do I do this?

Posting Permissions

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