Results 1 to 4 of 4
  1. #1
    Join Date
    Aug 2011
    Posts
    2

    Unanswered: How to make form write to two tables

    Hi
    I have form, it is currently writing to one table,
    but I also another table (history) I also want it to write to that table at the same time please help me how I can do this
    Thank you

  2. #2
    Join Date
    Mar 2009
    Posts
    5,442
    Provided Answers: 14
    You can:
    1) Build a query and use it as the RecordSource for the form.
    or
    2) When you want to append/update a row in the second table you can open a recorset on that table and use the AddNew/Edit + Update methods of the RecordSet object.
    or
    3) Assemble a SQL statement for INSERT/UPDATE and have it executed by the CurrentDb database object.
    Have a nice day!

  3. #3
    Join Date
    Aug 2011
    Posts
    2
    Hi
    can you please do it for me
    I am very new to access
    only used it for day or 2
    I can PM you the file
    plz help
    ty

  4. #4
    Join Date
    Mar 2009
    Posts
    5,442
    Provided Answers: 14
    No: without knowing the structure of the tables and what method you want to use, I can't.
    Please upload the database (at least a sample without real data in it) and I'll see what I can do.
    Have a nice day!

Posting Permissions

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