Forum Discussion

Tony2021's avatar
Tony2021
Iron Contributor
Jan 26, 2022
Solved

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 respons...
access
  • arnel_gp's avatar
    arnel_gp
    Jan 27, 2022

    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
Iron Contributor
Jan 27, 2022

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
Iron Contributor
Jan 27, 2022
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