Subform tied to Form comboboxes

[pmkieffe]

Hi,

I have a form with a recordset to populate a table. "Employee Name" is a combo box in the form. Can I create a subform that will list all of the corresponding past entries for each employee name when an employee name is selected in the combo box in the main form?

I want to be able to have a list of all records corresponding to a selection in a combo box on the main form. From this list I want to be able to select a record line and have that record thrown into the corresponding combo boxes in the main form to be edited.

Is this possible? Do I need code or just manipulate in design form? Please let me know if I should explain better.

Thanks,
pmkieffe

 

[pmkieffe]

Maybe a better way to ask is:

Can I basically have a subdatasheet appear on a form? But instead of clicking the plus sign of an entry in the table, can I have it appear when I select that entry in a combobox?

Thanks,
pmkieffe

 

[adalger]

What you want is called "Linked Forms". If you search on that, you'll find plenty of how-to info.