Hi guys,
I'm hoping some of you might be able to assist with this one:
I have one Unbound combo box on Main Menu Form (Search box if you like).
- User selects a participant from the combo box and a message box appears to advise the user in which form they will find the most recently completed transaction for this participant
- User clicks OK on the message box and that new form opens with the curser focused on the Unbound search combo box (where they will find that participant's name) in that form
My question is:
- How do I get the selected participant's name in the Unbound search combo box (Main Menu Form) to automatically populate into the Unbound search combo box when the new form opens? The primary key for participants (ParticipantID) is not in the same column in each of the other forms' Unbound combo box?
Thanks guys,
Kind regards Steve
I'm hoping some of you might be able to assist with this one:
I have one Unbound combo box on Main Menu Form (Search box if you like).
- User selects a participant from the combo box and a message box appears to advise the user in which form they will find the most recently completed transaction for this participant
- User clicks OK on the message box and that new form opens with the curser focused on the Unbound search combo box (where they will find that participant's name) in that form
My question is:
- How do I get the selected participant's name in the Unbound search combo box (Main Menu Form) to automatically populate into the Unbound search combo box when the new form opens? The primary key for participants (ParticipantID) is not in the same column in each of the other forms' Unbound combo box?
Thanks guys,
Kind regards Steve