All right, I've finally been able to hunker down on your form suggestion (I've been sidetracked a couple days...) but I'm having trouble getting it to come out right.
I searched the forum for how to do it, and came across a very helpful post, but I'm doing something wrong. (Help with combo boxes, Please!)
I've set up my form to not be bound to any table or query. I have my first list box (lstPosting) bound to a query that takes the AnnouncementNo from tblPosting, plus other information to help the user see which posting it is (positionNo, job title, office).
on the afterUpdate even of this combo box I have me.lstApplicants.requery.
Then my second list box (lstApplicants) is taken from a query which takes the AnnouncementID from tblJunction, plus other information to help the user identify the applicant (SSN, and Applicant, which joins the name fields into one field, easy to read.)
For the row source, I have:
SELECT DISTINCTROW [qryApplicantslstbox].[AnnouncementID], [qryApplicantslstbox].[ApplicationID], [qryApplicantslstbox].[SSN], [qryApplicantslstbox].[Applicant] FROM [qryApplicantslstbox] where ((([qryApplicantslstbox].[AnnouncementID])=[Forms]![FormView]![qryPosting].[AnnouncementNo]));
However, when I open the form I get an "Enter Parameter Value" message box, asking for: Forms!FormView!qryPosting.AnnouncementNo.
I have tried several different things, including in row source
...where ((([qryApplicantslstbox].[AnnouncementID])=[Forms]![FormView]![lstPosting])); (this is what the posting seems to suggest I do...
Anyway, any insight would be appreciated... I have tried set up relationships both in the queries and in the main relationships page... I've also tried to take both list boxes from the same query... I am stuck.
Thanks.
--Sara
I searched the forum for how to do it, and came across a very helpful post, but I'm doing something wrong. (Help with combo boxes, Please!)
I've set up my form to not be bound to any table or query. I have my first list box (lstPosting) bound to a query that takes the AnnouncementNo from tblPosting, plus other information to help the user see which posting it is (positionNo, job title, office).
on the afterUpdate even of this combo box I have me.lstApplicants.requery.
Then my second list box (lstApplicants) is taken from a query which takes the AnnouncementID from tblJunction, plus other information to help the user identify the applicant (SSN, and Applicant, which joins the name fields into one field, easy to read.)
For the row source, I have:
SELECT DISTINCTROW [qryApplicantslstbox].[AnnouncementID], [qryApplicantslstbox].[ApplicationID], [qryApplicantslstbox].[SSN], [qryApplicantslstbox].[Applicant] FROM [qryApplicantslstbox] where ((([qryApplicantslstbox].[AnnouncementID])=[Forms]![FormView]![qryPosting].[AnnouncementNo]));
However, when I open the form I get an "Enter Parameter Value" message box, asking for: Forms!FormView!qryPosting.AnnouncementNo.
I have tried several different things, including in row source
...where ((([qryApplicantslstbox].[AnnouncementID])=[Forms]![FormView]![lstPosting])); (this is what the posting seems to suggest I do...
Anyway, any insight would be appreciated... I have tried set up relationships both in the queries and in the main relationships page... I've also tried to take both list boxes from the same query... I am stuck.
Thanks.
--Sara