Use combo box selection to view related info in subform

[mcahal]

Hi, I've read posts about this, but can't find one that relates to exactly what I've done..



I have these tables with relations:


I'd like my main form to look something like this:


Should the Employee selection remain a combo box? Or is there an easier way? Right now, the first record for employee shows and has the correct assigned inventory. Would I use an "On Change" command?

[amrut]

You should use a text box for the employee field so that when you navigate form one record to other, the related records are displayed by the sub-form. One more option is still use the textbox bound to the employee field but hide it and use the above combo unbound. Navigate to the selected emplyoyee in the combobox AfterUpdate event.

[mcahal]

You should use a text box for the employee field so that when you navigate form one record to other, the related records are displayed by the sub-form. One more option is still use the textbox bound to the employee field but hide it and use the above combo unbound. Navigate to the selected emplyoyee in the combobox AfterUpdate event.

A text box sounds great! Is there a way to incorporate a drop-down into the text box? Also, is it possible to create a form with multiple subforms?

[amrut]

Use the second option with unbound combo box. You can use multiple sub-forms on a form. Use tabcontrol if you have space constraint.