Forum Discussion

Tony2021's avatar
Tony2021
Steel Contributor
Jan 26, 2022

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

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

  • arnel_gp's avatar
    arnel_gp
    Steel Contributor

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

    • Tony2021's avatar
      Tony2021
      Steel Contributor
      thank you very much Arnel! It works perfectly. I understand what you did and see where my approach was wrong. thank you once again.

Resources