I have a club membership database. The MEMBERS form has a subform called SF_LINK which displays, in datasheet format, the membership types that the member has, such as Friday nights, Saturdays, etc.

I have now introduced another drop down in my sub-form called ClubType. CTID is the index autonumber field.

Once I select the club type, I want the membership drop down to restrict itself to those memberships that apply to the club type selected.

How do I do this from within the MEMBERS form?