|
I have a main form that contains a listbox. The user must choose from the list of Scheduled Classes.
I have the following tables
tblScheduleSetup
tblSupplierInformation
tblRoster
the tblScheduleSetup contains all the class information. The user must choose the correct class, then the next subform tblSupplierInformation contains all the Supplier number/address/etc.... User must choose the proper supplier that the student corresponds with. Then, the last subform is the tblRoster. This contains the student names / dates of class / locations of class etc...
I need to have all the choices made from the listbox in the main form, the supplier information from the tblSupplierInformation subform all append / populate / or add with the Student information into the tblRoster when the user is done entering students for that particular class.
What is the code to populate the tblRoster? I'm stuck.
thanks for any help at all.
| 
