I'm trying to link a listbox on page index 1 (second tab from left) to a subform on that same page. Seems like it would be easy but it's not taking anything I give it. Subform would keep notes to each record in the listbox I select with the mouse.
Tab Control: TAB_CTRL_PAGES
Page: TAB_OPEN_BALANCES
ListBox: LST_OPEN_BALANCES
ListBox Source ID: BALANCE_ID
Sub Form: SUBFRM_NOTES
Sub Form Source ID: BALANCE_ID
Both listbox and subform are driven from queries. Relationships between the two tables that drive the queries on the page do not have referential integrity, but are outer joined.
Any help would be appreciated.
Tab Control: TAB_CTRL_PAGES
Page: TAB_OPEN_BALANCES
ListBox: LST_OPEN_BALANCES
ListBox Source ID: BALANCE_ID
Sub Form: SUBFRM_NOTES
Sub Form Source ID: BALANCE_ID
Both listbox and subform are driven from queries. Relationships between the two tables that drive the queries on the page do not have referential integrity, but are outer joined.
Any help would be appreciated.