Results 1 to 4 of 4
  1. #1
    Join Date
    Aug 2010
    Posts
    25

    Exclamation Unanswered: Save data from the form to a table

    Hi Friends,
    I am new to access. I have a form in access (text boxes) and I want that data to be saved in a new table by clicking on a button. Please help me with the code that I need to use.

    Thanks
    saby

  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    use a bound form and it will do the work for you
    failign that go down the route of unbound controls
    and place some code behind the add button which saves the record
    I'd rather be riding on the Tiger 800 or the Norton

  3. #3
    Join Date
    Aug 2010
    Posts
    25
    I have this form which is picking some information from another subform and I have only Specific information from that table and the new data to be saved in the new form. Which is not working with what you are saying. Can you help

  4. #4
    Join Date
    Oct 2009
    Posts
    204
    You could use a combination of append queries and update queries and code the button to run them...but that is a more clumsy way of doing it. Bound forms are best.

Posting Permissions

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