Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2003
    Location
    Manchester, NH
    Posts
    57

    Question Unanswered: Want to insert field data into table other than recordsource

    I have a form that is used to enter new jobs. I want to also put 2 of the fields data into a second table which is not the recordsource. I can have it ewnter the data into the second table either on the Onclick of the save button or on Form Unload. I am using MS Access 2k. Thanks for any help you guys can give.



    Kevin

  2. #2
    Join Date
    Feb 2002
    Posts
    403
    An update or append query can do this, depending on what you want to do. To modify existing you would use an update to add new an append. The form fields become the source data for the query.

    HTH

Posting Permissions

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