Subform - Combo Box Help

G

Guest

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
 
J

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.
 
G

Guest

Yes they are - same as Social Security

Jeff L said:
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.
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Combo Box - Subform 1
Form, subform and combo box 1
synchronized Combo Boxes in subforms 2
Combo Box results to Subform 1
having combo box on subform reading many relationship 3
Combo box not populating subform 1
Problem with registering 1
Combo Box Help 3

Top