Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Link Subform to ListBox On Same Page Index/Tab 1

Status
Not open for further replies.

Fattire

Technical User
Nov 30, 2006
127
US
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.



 
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.


 
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.
 
Well yours worked... as usual.

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

Part and Inventory Search

Sponsor

Back
Top