Results 1 to 4 of 4
  1. #1
    Join Date
    Oct 2003
    Posts
    7

    Question Unanswered: Have Same Records in 1 Table automatically Fill in Another Table?

    Is there a way to have the same records from Table 1 automatically fill in in Table 2 w/o having to do an append query? If so, how?

  2. #2
    Join Date
    Oct 2003
    Location
    São Paulo - Brazil
    Posts
    91

    Re: Have Same Records in 1 Table automatically Fill in Another Table?

    Originally posted by vbhelpme
    Is there a way to have the same records from Table 1 automatically fill in in Table 2 w/o having to do an append query? If so, how?
    You may create a RecordeSet and append new records on it.
    My environment: Windows XP/ Access 2000 - Using Microsoft DAO 3.6 Library

  3. #3
    Join Date
    Nov 2003
    Posts
    14
    Are you using a form to enter the data?
    If you are, you could run an event after the data has been entered into the form (and hence into Table1) to copy the data to a second table.

  4. #4
    Join Date
    Sep 2003
    Posts
    29
    Have you thought about an Update query, or is that possible with your current requirements?

Posting Permissions

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