Relationship: 1(RefNo) to many(discipline)
Main Form
Pop-up form
tblPertinence
Everything fine except that I need my Pop-up form to have the checkbox set to true if the ID from Main form/table match to those IDs on tblPertinence according to which record the user clicked to. I'm new to vba and most of my work was made by googling. Kindly see attachment. Thanks
Main Form
- Fetch its records from a query (Select * from tblEntry 'the main table)
- Contain the discipline object
- Discipline object having the on_click event and if triggers, it open the Pop-up form
- Discipline field calls concatDiscipline module and fetch its record from tblPertinence
Pop-up form
- Contains checkbox and description object
- Fetch its records from a query (Select * from tblDiscipline)
- The window for setting and viewing (viewing-based on ticked checkboxes) as per the records from/to tblPertinence
tblPertinence
- Stores the ID and Discipline being entered by user from Pop-up Form.
Everything fine except that I need my Pop-up form to have the checkbox set to true if the ID from Main form/table match to those IDs on tblPertinence according to which record the user clicked to. I'm new to vba and most of my work was made by googling. Kindly see attachment. Thanks
Attachments
Last edited: