If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Subform - Combo Box Help
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 |
#2
|
|||
|
|||
Subform - Combo Box Help
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 wrote: 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 |
#3
|
|||
|
|||
Subform - Combo Box Help
Yes they are - same as Social Security
"Jeff L" wrote: 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 wrote: 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 |
Thread Tools | |
Display Modes | |
|
|