I currently have a form with 2 combo boxes on it. One combo box has a list of participants that is pulled from a participant table. The other combo box are referrals, which a participant can have many of.
When you have both combo boxes selected there is a "Report" button that displays the appropriate report. Everything works as intended, but I am having a problem with the display problem of the 2nd combo box.
The query of the 2nd combobox has 4 fields (ParticipantID, RSID, Name, Date). The Criteria of the ParticipantID is what determines what records to display in this combobox. My question though is, right now when you click the Referral you want in the 2nd combo box (example: 10 Rick Armstrong 5/11/2012) , After selection it puts only the RSID in the combobox to display. How can I fix this to display everything you selected, but still use the RSID to get the appropriate record.
Thank you in advance,
Rick
When you have both combo boxes selected there is a "Report" button that displays the appropriate report. Everything works as intended, but I am having a problem with the display problem of the 2nd combo box.
The query of the 2nd combobox has 4 fields (ParticipantID, RSID, Name, Date). The Criteria of the ParticipantID is what determines what records to display in this combobox. My question though is, right now when you click the Referral you want in the 2nd combo box (example: 10 Rick Armstrong 5/11/2012) , After selection it puts only the RSID in the combobox to display. How can I fix this to display everything you selected, but still use the RSID to get the appropriate record.
Thank you in advance,
Rick