Subform - Combo Box Help

[George]

On my form I have a combo box and two subforms. My suforms have just
a few fields - Last Name, First Name, Social Security Number.

When I select their name from the combo box all that fills in in the subform
is
their social security number. I tried tweeking the relations between the
tables but that didn't help.

Other then taht the subforms are working

Any ideas

Thanks - George

 

[Jeff L]

Are the name fields in the subform bound controls to a field in the
subquery's record source? It would appear that the SSN is bound, but
the name fields are not.

 

[George]

Yes they are - same as Social Security

Are the name fields in the subform bound controls to a field in the
subquery's record source? It would appear that the SSN is bound, but
the name fields are not.