Display all records on one side

[Tony2021]

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

[#2 · Accepted solution]

@Tony2021 

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?).

[#3]

thank you very much Arnel! It works perfectly. I understand what you did and see where my approach was wrong. thank you once again.