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