megatronixs
Registered User.
- Local time
- Today, 17:19
- Joined
- Aug 17, 2012
- Messages
- 719
Hi all,
I have a subform with a combobox. the combobox will need to get me a selection of a participant that has her/his name in one of the records.
For example in record 3 I have 3 participants "John Potter, Amelia Blake, Peter Cetera"
If the form is showing the data for record id 3, then clicking on the combobox would give me the choice as from above, if on another record nr, then those ones from that record.
I tried the below, but without luck:
this is the SQL that is on the row source of the combobox.
Greetings.
I have a subform with a combobox. the combobox will need to get me a selection of a participant that has her/his name in one of the records.
For example in record 3 I have 3 participants "John Potter, Amelia Blake, Peter Cetera"
If the form is showing the data for record id 3, then clicking on the combobox would give me the choice as from above, if on another record nr, then those ones from that record.
I tried the below, but without luck:
Code:
SELECT [tbl_invitation_participant_name].[participant_name] FROM tbl_invitation_participant_name WHERE record_id = Me.record_id;
Greetings.