How do I Link multiple List boxes to one subform?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi, Im still a beginner in access but I managed to connect a list box to a
subform. I am interested in having 2 or 3 list boxes on the same main form
and when you select one of the items on any of the list boxes it will appear
in the subform.

I can do the one with the whole child and master values, but can this be
done with 2 or more list boxes?
 
Hi, Im still a beginner in access but I managed to connect a list box to a
subform. I am interested in having 2 or 3 list boxes on the same main form
and when you select one of the items on any of the list boxes it will appear
in the subform.

I can do the one with the whole child and master values, but can this be
done with 2 or more list boxes?
Click to expand...

This is confusing. What are the Rowsources of the listboxes? What is the
Recordsource of the subform? That's sort of like having three different phone
books and calling the same number in a different way depending on which
phonebook you use...

What is the context? Why three listboxes, and just what are you trying to
accomplish?

John W. Vinson [MVP]
 
Sorry, if it was confusing. The two list boxes are for different queries on
the same table. I wanted to show the different info in two seperate
locations. The subfrom is just a nicer expanded view of the list. I set up
the subform with the child and master links to the first list box (I have
that working) , but was wondering if it was possible to set it up to both
list boxes? ie. click on record in list boxA it shows in subform, click
record in list boxB it now shows in subform.
 
Sorry, if it was confusing. The two list boxes are for different queries on
the same table. I wanted to show the different info in two seperate
locations. The subfrom is just a nicer expanded view of the list. I set up
the subform with the child and master links to the first list box (I have
that working) , but was wondering if it was possible to set it up to both
list boxes? ie. click on record in list boxA it shows in subform, click
record in list boxB it now shows in subform.
Click to expand...

Not directly, no. You may be able to use VBA code in the second listbox's
AfterUpdate event to set the first listbox's value to the selection from the
second listbox; or (more complex I suspect) change the subform's properties.

John W. Vinson [MVP]
 
Back
Top