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:
- Program - a list of all the programs that use this db
- Fixtures - a list of all the fixtures each program uses and all the O-rings required
- 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.
Access 2013 - W10
Thanks for any assistance!