janerussel
MIS
My Main form has two key fields. [ComplaintNo] and [IncidentNo]. Each record has a [ComplaintNo], but only some have [IncidentNo].
The Subform is related to main form by [IncidentNo]. It is based on a table "Colors". "Colors" table has an IncidentNo field and a color field. There can be many IncidentNos that have a corresponding color.
The subform contains a combo box with a list of colors. I would like the combo box to contain only the colors that relate to the incident number on the record on the main form. Each record on the main form can have a different set of colors depending on what the Incident No is.
Users can populate the Colors table separately with all the colors that apply to a particular incident.
I can't get the combo box to filter the colors so only the ones related to the incident are displayed.
Any solutions?
The Subform is related to main form by [IncidentNo]. It is based on a table "Colors". "Colors" table has an IncidentNo field and a color field. There can be many IncidentNos that have a corresponding color.
The subform contains a combo box with a list of colors. I would like the combo box to contain only the colors that relate to the incident number on the record on the main form. Each record on the main form can have a different set of colors depending on what the Incident No is.
Users can populate the Colors table separately with all the colors that apply to a particular incident.
I can't get the combo box to filter the colors so only the ones related to the incident are displayed.
Any solutions?