B
BIll Mills
I have a main form based on a table called IncidentTrainee. In that table
has a value called contactid and trainerid. I have a second table called
Contacts that has a field called contactid (unique index) and has all contact
information. My main form is based on the IncidentTrainee table (with the
contactid and trainerid values)and my 2 subforms are based on the Contacts
table. I am trying to use a combo box to select a contactid and a trainerid
from the Contacts table and store the appropriate value in the
IncidentTrainee table. The problem I am having is when selecting the value
from the combo box, it doesn't populate the fields on the subform with all of
the other information such as last name and first name. It seems as though
the combo box is populating correctly and storing the approriate value in the
Incidenttrainee table, but doesn't display the info in the sub form? Any
ideas??
has a value called contactid and trainerid. I have a second table called
Contacts that has a field called contactid (unique index) and has all contact
information. My main form is based on the IncidentTrainee table (with the
contactid and trainerid values)and my 2 subforms are based on the Contacts
table. I am trying to use a combo box to select a contactid and a trainerid
from the Contacts table and store the appropriate value in the
IncidentTrainee table. The problem I am having is when selecting the value
from the combo box, it doesn't populate the fields on the subform with all of
the other information such as last name and first name. It seems as though
the combo box is populating correctly and storing the approriate value in the
Incidenttrainee table, but doesn't display the info in the sub form? Any
ideas??