• Link subform to main form with combo box?

    Home » Forums » AskWoody support » Productivity software by function » MS Access and database help » Link subform to main form with combo box?

    • This topic has 2 replies, 2 voices, and was last updated 16 years ago.
    Author
    Topic
    #460510

    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

    Viewing 0 reply threads
    Author
    Replies
    • #1164834

      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.

      • #1164837

        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

    Viewing 0 reply threads
    Reply To: Link subform to main form with combo box?

    You can use BBCodes to format your content.
    Your account can't use all available BBCodes, they will be stripped before saving.

    Your information: