Set values in subform based on combo box selection

[shira47]

Without going into too many details…I could use some help with a basic concept.



I have a form with a subform. The main form has a combo box called Process Name, and the subform is in datasheet mode (if that matters) and has places to enter multiple Parameter Names that are specific to each process (and there are appropriate tables and relationships in place so the database knows which parameters belong to which processes).

In an ideal world, I would like to have the user select the Process name from the combo box and a list of default Parameters appear in the subform.

Any suggestions? I'd prefer to use some sort of macro but fear that VBA is the only solution...


Thanks in advance!

[June7]

What do you mean by 'list of default Parameters' - a combobox RowSource list or a set of records?

The first is dependent comboboxes, the second will need VBA code and is not a basic concept and can get very tricky.