hello.
i also have two list boxes in my form and i follow the recommendation here. here is the final code:
Private Sub lstOrg_Click()
Me.lstMembers.RowSourceType = "Table/Query"
Me.lstMembers.RowSourceType = "SELECT tblMembers.tOrgNick, tblMembers.tFName, tblMembers.tMName...