By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,224 Members | 1,143 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,224 IT Pros & Developers. It's quick & easy.

Populate a subform from a Combo box

P: 1
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?
Jan 3 '07 #1
Share this Question
Share on Google+
5 Replies


NeoPa
Expert Mod 15k+
P: 31,660
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 :).
Jan 3 '07 #2

MMcCarthy
Expert Mod 10K+
P: 14,534
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
Jan 3 '07 #3

NeoPa
Expert Mod 15k+
P: 31,660
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.
Jan 4 '07 #4

MMcCarthy
Expert Mod 10K+
P: 14,534
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????????????????
Jan 4 '07 #5

NeoPa
Expert Mod 15k+
P: 31,660
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!)
Jan 4 '07 #6

Post your reply

Sign in to post your reply or Sign up for a free account.