Populate a Listbox from a query record
Posted on 2011-10-27
I have a form to select a contract. When the contract is selected, it opens a second form
("frmMainTab") with the contract's information (pulled from a query record) shown in several textboxes.
Here's the code that opens the second form:
Private Sub List33_DblClick(Cancel As Integer)
DoCmd.OpenForm "frmMainTab", , , "ContractNameID = " & Me.List33
The second form needs a list box to show the client board members for the contract. All I can do so far is get it to show all the board members for all the contracts.