Good morning!
I have a Combo box that is supposed to populate a field in a subform. The
Combo box field is named RCIID and the Subform field name is ExchgID. In
the
link between the two RCIID is the master and ExchgID is the child. When I
pull down and select an entry from the Combo box, it does not populate in
the
subform. The key to the table driving the combo box on the main form is
RCIID while the key to the table driving the subform is Splist, DateofWk,
and
ExchgID. I have been trying different events to get it to populate. If I
code
Me!Verifsubform!ExchgID = Me.Combo14.Column(0) I will get it to populate
but
then get a popup box that states you cannot have a null value in a key.
The
sequence I want to happen is this.
1. User selects resort from combo box on main form and it populates on
subform.
2. User selects their name from combo box on subform and it populates on
subform.
3. User enters numbers for production and exits.
4. Upon re-entry, If they re-enter same resort, same name, and same date,
they should see the data they entered previously and be able to re-key.
ANY HELP would be greatfully appreciated!
