Here is what I would like to happen, just not sure of which way to approach it to make it the most user friendly.
This is a Grant database. Current structure:
frmMain
cboGrant - allows you to select from currently active Grants in the DB
lstAuthorizedTrainingProviders - once grant is selected above this listbox automatically to show authorized training providers for this grant
cboStudent - this combobox allows you to select students that have taken a class with the selected Training Provider for the above lstbox
lstClassesTaken - automatically populates what classes the student has taken with that company when the student is selected
frmAddNewGrant
txtID - autonumber to provide unique identity for grant
txtGrantName - allows user input to name the grant
lstTrainingProviders - lists all Training Providers that are in the database
cmdAddNewGrant - intitiates VBA that adds the Grant information into tbl1Grants as well as adds all selected Training Providers in lstTrainingProviders to tbl2GrantTrainers in order to accurately display information on frmMain
I would like to know the most user friendly way to be able to have the next step of the cmdAddNewGrant to either pop up a new form that has a listbox for the first selection in lstTrainingProviders in order to select what classes that Training Provider offers under the newly created grant, or a similar option in order to accomplish this task. Any ideas are welcome!