Link Subform to ListBox On Same Page Index/Tab 1

[Fattire]

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.

 

[Fattire]

Oh, I tried a variation of things such as:
Child: BALANCE_ID
Master: Forms!FRM_MAIN!LST_OPEN_BALANCES.Column(0)

or

Child: BALANCE_ID
Master: Forms!FRM_MAIN!TAB_OPEN_BALANCES!LST_OPEN_BALANCES.Column(0)


And I always get the "Enter Paramter Value" window or nothing happens at all.

 

[MajP]

should simply be
master:[LST_OPEN_BALANCES]
child: [BALANCE_ID]

no need to reference the form since they are on the form. However, there may be some other problem because your 1st attempt looks correct.

 

[Fattire]

Well yours worked... as usual.

Not sure why, maybe its the page that needs something more - or less as your solution proves.