Forum Discussion
Display all records on one side
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
see 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?).
- arnel_gpSteel Contributor
see 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?).
- Tony2021Steel Contributorthank you very much Arnel! It works perfectly. I understand what you did and see where my approach was wrong. thank you once again.