D DS Sep 2, 2005 #1 Whenever I click on a record in a Listbox I want a Subform to update accordingly. How would I do this? Thanks DS
Whenever I click on a record in a Listbox I want a Subform to update accordingly. How would I do this? Thanks DS
D Duane Hookom Sep 2, 2005 #2 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.
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.
D DS Sep 2, 2005 #3 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... 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
D DS Sep 2, 2005 #4 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
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
D Duane Hookom Sep 2, 2005 #5 I assume this is now working. A tip for future development: Give your controls descriptive names like "lboSalesID" rather than "List13".
I assume this is now working. A tip for future development: Give your controls descriptive names like "lboSalesID" rather than "List13".
