Link subform to main form with combo box?

Topic

New Reply

I have a main form with a combobox. This combo box, Combo97, is unbound and gets its choices from lkpTerm. My subform, subfrmCCourses, is a list of courses and has a field called Term. I would like the subform to only show me the records where Term=Combo97. I have the Combo97 go to default value of current term so they may not have to update it.

This seems like a simple thing, but I can’t figure it out since you can’t set Combo97 as a Master Field for the Child Field of Term.

Jodi

Reply | Quote

Replies

The “Wizard” doesn’t let you select an unbound control as master field, but you can set it manually – just enter the name of the combo box in the Link Master Fields property.

Reply | Quote

The “Wizard” doesn’t let you select an unbound control as master field, but you can set it manually – just enter the name of the combo box in the Link Master Fields property.

Thanks so much! I knew it had to be something easy like that. That worked perfectly.

Jodi

Reply | Quote