Results 1 to 3 of 3
  1. #1
    Mario6186 is offline Novice
    Windows 10 Access 2013 64bit
    Join Date
    May 2017
    Posts
    1

    Form populated from a few tables - want to save to a new table

    Hi folks, I have been searching for an answer for days now and I cannot seem to find the answer I am looking for.



    I have a form that acts like an invoice. I have three tables that populate the form:
    1. Program - a list of all the programs that use this db
    2. Fixtures - a list of all the fixtures each program uses and all the O-rings required
    3. Users - A list of all the users


    So the form uses dynamic results based on two comboboxes
    • Selecting the program in cboProgram populates cboFixture with all the fixtures associated with that program
    • Selecting the fixture populates several listboxes with the orings needed and another set of listboxes with the quantity


    Once that info populates they use another combobox to select their name.

    All the above works and maybe it isn't the proper way but this is what I did:

    • Comboboxes are populated using Row Source and using the respected table
    • Under Criteria in Row Source - built an expression to populate based on the results of the previous CBO
    • Set a couple macros to requery after the CBO updates


    What I am trying to do is use a button to populate a new table with the info from the form. Essentially a log/invoice of the transactions. However, I have been unable to figure this one out.

    Click image for larger version. 

Name:	form.png 
Views:	8 
Size:	7.8 KB 
ID:	28815

    Access 2013 - W10

    Thanks for any assistance!

  2. #2
    aytee111 is offline Competent At Times
    Windows 10 Access 2013 64bit
    Join Date
    Nov 2011
    Location
    Nomad
    Posts
    3,936
    Bind the form to the table you are adding to (record source property). You say you have three tables that populate the form, not quite correct, each of those tables populates one field. Once a selection is made, e.g. program, the combobox is bound to the table using the program ID. Add all fields that you want populated and let Access do it for you. A save button is not required as the data will be automatically saved once you leave that window.

  3. #3
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    Once the user picks all items, and clicks Check out, youd run an append query to post the items into the tTransaction table.
    then you can print/report/lookup on anything done here.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 3
    Last Post: 09-22-2015, 10:19 AM
  2. Replies: 1
    Last Post: 11-29-2013, 08:35 AM
  3. Replies: 1
    Last Post: 11-28-2012, 01:01 PM
  4. Replies: 8
    Last Post: 02-19-2012, 03:48 PM
  5. Replies: 9
    Last Post: 01-20-2011, 02:22 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums