Populate a subform from a Combo box

[KCProg]

I created a form with a subform. I can populate the subform by moving from record to record in the main form but this is time consuming.
I created a combo box on the main form which is populated with a list of all students taken from the student table. It contains the student first name, student last name and student ID. I want the student that is clicked on in the combo box to populate the sub form with the students visit data from the student visit table. It contains the student ID and student visits dates. When I click on the student in the combo box nothing changes in the subform. What do I need to do to correct this?

[NeoPa]

I think your first step should be to re-arrange this question.
Start by giving the information without which any reader is lost.
Layout of tables etc. The database structure.
Next explain what you're trying to achieve.
Lastly, say how far you've got and explain what is going wrong.
At this point, assuming the other bits have been clearly explained, the reader will understand where you're coming from and may well be able to help.
We have many very experienced experts on this site but we all need to understand the problem before we are in a position to offer help... and we like to help :).

[MMcCarthy]

I created a form with a subform. I can populate the subform by moving from record to record in the main form but this is time consuming.
I created a combo box on the main form which is populated with a list of all students taken from the student table. It contains the student first name, student last name and student ID. I want the student that is clicked on in the combo box to populate the sub form with the students visit data from the student visit table. It contains the student ID and student visits dates. When I click on the student in the combo box nothing changes in the subform. What do I need to do to correct this?

In the object properties of the subform make sure the master field is set to the combo box and the child field to studentID. You will also have to put an after update event on the combo box to reuery the subform object.

Mary

[NeoPa]

Mary, of course, has an uncanny ability to read and make sense of things that can turn my brain inside out.
This is just one of the reasons we love her so much - that and her prolific work-rate.

[MMcCarthy]

Mary, of course, has an uncanny ability to read and make sense of things that can turn my brain inside out.
This is just one of the reasons we love her so much - that and her prolific work-rate.

You LUVVVVVVVVVVV Me????????????????

[NeoPa]

Don't try that 'I'm still a school aged individual' line with me Mary McCarthy (As said by a sister of the Ladies of Mary)!
I know better than that.
(But of course we do!)