Hi,
I currently have a select form where users select a record based on BorrowerTitle, FacilityName,CommitmentID using a single listbox and then clicking a button to open the selected record in edit mode.
This has caused a problem as BorrowerTitle and TitleAgreement can have many facilityNames so what i want to do is first user will select BorrowerTitle and CommitmentID in the first listbox(My borrowertitle and CommitmentID have a relationship so its counted as a single record) and subsquently the facilities related to borrowertitle/CommitmentID will appear on the second listbox so that i can select them and edit them. Currently I am using a button to open records and this is my code:
Code:
DoCmd.OpenForm "AddCommitmentDetail", , , "CommitmentID=" & Me.ListShowCommit.Column(0)
I think i only need help in linking the two listboxes together as i know how to open the selected record using the code i mentioned above.
BorrowerTitle belongs to tblBorrower,CommitmentID belongs to tblCommit,FacilityName belongs to tblFacility
CommitmentID has one-to-many relationship with tblfacility