linking subform to Listbox

  • Thread starter Thread starter DS
  • Start date Start date
D

DS

Whenever I click on a record in a Listbox I want a Subform to update
accordingly. How would I do this?
Thanks
DS
 
Set the Link Master and Link Child properties to the list box and the field
name on the subform that corresponds with the value in the list box.

This only works with single select list boxes.
 
Duane said:
Set the Link Master and Link Child properties to the list box and the field
name on the subform that corresponds with the value in the list box.

This only works with single select list boxes.
Click to expand...
Like This
Childfield SalesID
Masterfield Forms!DiscountApply!List13.Column(0)

This is what I tried. It's on the OnClick of the listbox.
Its not working. Is it my Syntax?
Thanks
DS
 
Duane said:
Set the Link Master and Link Child properties to the list box and the field
name on the subform that corresponds with the value in the list box.

This only works with single select list boxes.
Click to expand...

I only had to put the name of the Listbox in the Masterfield

ChildLink SalesID
MasterLink List13

Thanks
DS
 
I assume this is now working.

A tip for future development: Give your controls descriptive names like
"lboSalesID" rather than "List13".
 
Back
Top