Populate a subform with data

[intransit2]

Situation: I wish to automate a process to associate a given student in a class with one of 3 different training schedules contained in separate tables. I currently use a form (student info)/subform (training schedule) and copy/paste the training schedule data from the appropriate table into the subform. I would like to automate this process so that users could select a training schedule for an individual using an options button and have the subform populate with the data from the appropriate table. If this is possible in VBA, what would the code look like?

[June7]

Recommend, in order of my preference:

1. combine the 3 tables into one Schedules table and filter the dataset - 3 identical tables is indicator of poor db design

or

2. have 3 subforms set as not visible and use VBA code to manage which one is made visible to the user

or

3. VBA code sets the RecordSource property of the subform - never actually tried this one