Jan 26 2022 10:53 AM - edited Jan 26 2022 03:49 PM
Hello,
I have a parent and subform setup.
The parent is based on tblDRaws
Subform is based on a query of tblCompliance and tblEmployees
What I am doing is a survey and tracking the responses for each record in tblDraws.
I open the parent form
Select the number from the cbo
i want to be able to see all the employees after I select the number in the cbo
I send out the survey to all the employees and record the datesent, datereceived and I can easily see who has not responded for each record in tblDraw. Repeat for the new choice in the cbo meaning that I see a new list of the employees to fill in the data once again (ie datesent, date received...)
I hope that is not confusing. It would be easier to see what I am trying to do by looking at the database attached. The form opens automatically.
My approach might not be correct.
thank you very much
Jan 26 2022 07:52 PM - edited Jan 26 2022 08:01 PM
Solutionsee the AfterUpdate event of the combobox.
note the Main form, i made it Unbound.
and i change the Master Link Fields to your combobox.
also check Draw table, you have duplicate DrawNo (esp. Draw 14?).
Jan 27 2022 12:22 PM
Jan 26 2022 07:52 PM - edited Jan 26 2022 08:01 PM
Solutionsee the AfterUpdate event of the combobox.
note the Main form, i made it Unbound.
and i change the Master Link Fields to your combobox.
also check Draw table, you have duplicate DrawNo (esp. Draw 14?).