help with using combobox to trigger a subformlist and detail in a

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

Guest

Hi all,
If someone can please help with the following task:
1) using a combox (selection from a query) to select which record to display
in subformList.
2) based on user click on which row on the subFormList, all the details
(fields related to the subformList) will be displayed on the subformDetail
within the same form.

e.g. table "student" contains name of each students (items in the combobox)
subformList shows all the classes (items in table "courses" a student (combo
selection) is taking, when an user click on a row (course), it shows all the
detail related to the course (table "courseDetails").

Thanks
 
Jeff said:
Hi all,
If someone can please help with the following task:
1) using a combox (selection from a query) to select which record to display
in subformList.
2) based on user click on which row on the subFormList, all the details
(fields related to the subformList) will be displayed on the subformDetail
within the same form.

e.g. table "student" contains name of each students (items in the combobox)
subformList shows all the classes (items in table "courses" a student (combo
selection) is taking, when an user click on a row (course), it shows all the
detail related to the course (table "courseDetails").

Thanks
Click to expand...

It id dificult to envisage exactly what you problem is. As far as I can make
out, if you use the combobox to go to the record in you master form, the sub
table lnked to that form will display the relevent information.

Clickin further on the sub form, could open another independent form with
the additional information you want to display.
 
William K. Hamilton said:
It id dificult to envisage exactly what you problem is. As far as I can make
out, if you use the combobox to go to the record in you master form, the sub
table lnked to that form will display the relevent information.

Clickin further on the sub form, could open another independent form with
the additional information you want to display.
Click to expand...

that is close.
say, i have a table named students, it has nothing but student names. I
wrote a query so the names appears on the combobox.
depends on what the user clicked on the combobox, all the classes that
student has registered (under a query look up info for that student selected
on the combobox) shows up on subform1 (summary, some fields are not
displayed). whatever is clicked on subform1, the detail (all the fields for
that record will show up under subform2)

Thanks.
 
Back
Top