populating subform with data from linked table

[gmanship]

I am attempting to populate multiple fields in a subform with data from
a linked table. I created a combo box that queries the linked table
but it only populates the combo box. What do I need to do to query the
record in the combo box and have it fill all the fields in the subform?
Any help would be appreciated. Thanks.

 

[Guest]

I am attempting to populate multiple fields in a subform with data from
a linked table. I created a combo box that queries the linked table
but it only populates the combo box. What do I need to do to query the
record in the combo box and have it fill all the fields in the subform?
Any help would be appreciated. Thanks.

It sounds like you want to use the combo box as a search field.
Use the Combo Box Wizard to guide you through the basics. On the first
screen, you'll need to choose "Find a record on my form based on the value I
selected in my combo box" and go from there.

Hope that helped.