Does anyone know how to retrieve data from two or three listbox o.

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

Guest

I have a form with 3 listbox link to 3 different tables and a subform that I
would like to display data base on the values selected in those listbox
fields.
is anyone here able to help?
 
I have a form with 3 listbox link to 3 different tables and a subform that I
would like to display data base on the values selected in those listbox
fields.
is anyone here able to help?
Click to expand...

It's not altogether clear how your database is set up, but one
possible solution would be to set the Master Link Field property of
the subform to

ListBox1;ListBox2;ListBox3

using the actual Name properties of your three list boxes. Set the
Child Link Field to the names of the three fields in the subform's
recordsource which correspond to the values in the listboxes' bound
columns.

John W. Vinson[MVP]
 
thanks, these posts were most helpful.
:-)


John Vinson said:
It's not altogether clear how your database is set up, but one
possible solution would be to set the Master Link Field property of
the subform to

ListBox1;ListBox2;ListBox3

using the actual Name properties of your three list boxes. Set the
Child Link Field to the names of the three fields in the subform's
recordsource which correspond to the values in the listboxes' bound
columns.

John W. Vinson[MVP]
Click to expand...
 
Back
Top