Help on EVENTS

B

Bunky

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!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Clearing combo boxes and a text box 2
Dynamic Naming of Form Button 3
Populate main form from subform record 0
Link a text box based on drop down box with four options MS Word 365 0
Auto populate value from one task to another in MS PROJECT 0
Trying to get a combo box to auto populate on a subform 4
Open a form from a combobox on the switchboard based on a field inthe subform 1
Problem with form--subform 5

Top