Using Combo Box linked to subform

[SVNTY7]

Hello,

I have a "Pop-up" form that asks the user to selected a Participant from a combo box list. The user then hits SUBMIT button, and opens a form. The problem I am having, is that the participant is a field in a subform that is one the form that the user is trying to open. I can not get the form to open with the correct participant selected. How do I reference the subform participant field?

Thanks in advance

Svnty7

 

[llkhoutx]

Hopefully you have an indexed ID identifying the participant. One way is to filter the form with the participant ID.

Example:

sfilter = "[ParticipantID]=" & cboParticipantID
forms!yourform!filter=sfilter
forms!yourform.filteron=true
forms!yourform.requery

yourform should dusplay the correct record.