Using list box to control subform

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

Guest

I have a form with two levels of subform. The main form is for entering a
standard title, the first level of sub forms is for entering the issue date,
and the second level of subform is for entering the amendment number (each
standard has many issue dates and issue date has many amendments).

As it is currently setup the user must use the record selectors on the first
subform to move through the issue dates one at a time.

What I would like to do is have a list box which displays all the issue
dates and have my second sub form linked to the selection in the list box.
i.e. the subform will display the appropriate data according to the list box
selection.

In order to achieve this do I have to somehow set the subform Link
Child/Master fields to the listbox?


Regards,
Seth
 
Seth,

Yes. Set up the Listbox so that its Bound Column in the field that
relates it to the Amendments (presumably the Primary Key fiend of youe
Issue Dates table). It sounds like you can dispense with the Issue
Dates subform, put the Amendments as a subform directly onto the
Standards form, and set its Link Master Fields property to the name of
the Listbox. Im not sure without trying it... you may have to requery
the Amendments subform on the Listbox's After Update event.
 
Back
Top