Combo Box Searching (1 Viewer)

Hi all

I have caused a little bit of confusion with my earlier post and am re-posting my question sorry.

I am wanting to get the combo box to display the multiple search matches in a drop down as I type each letter. Then I select the appropriate one from the drop down to display the details on my sub-form. Pic attached.

Can someone help, Thanks Greg:banghead:

Ordinarily subforms usually tumble wit a main form.

What's the subform to display before the combo box row is selected?

One method is to use the subform Filter and FilterOn properties be set of th combo box AfterUpdate event.

What are you going to do on the subform, after the records are filtered?