Combo Box - Subform

On my previous question I mentioned that I have a combo box and two subforms
on a single form. When I select a name from the combo box it only fills in is
the SS# field on my subform. The Last name and First Name remain blank. The
Combo box and subforms extract their data right from their tables. So to fill
in the two missing fileds on my subforms I add this to the subform fileds
=Forms![F-Compt-Time-History]!Combo2.Column(1)

Which now enters the missing data in the subform but what it does not do is
add the data to the table that the data comes from !

Seemed like a good work around but created another problem.
So the only thing in the table is the SS # -

So if I can't fix my original problem how can I tell the table to convert
the SS # field to update the Last Name + First Name field ?

Properly normalized, all that need to go in the table is the PrimaryKey of
the table with the SS# as a ForeignKey.

George wrote:
On my previous question I mentioned that I have a combo box and two subforms
on a single form. When I select a name from the combo box it only fills in is
the SS# field on my subform. The Last name and First Name remain blank. The
Combo box and subforms extract their data right from their tables. So to fill
in the two missing fileds on my subforms I add this to the subform fileds
=Forms![F-Compt-Time-History]!Combo2.Column(1)

Which now enters the missing data in the subform but what it does not do is
add the data to the table that the data comes from !

Seemed like a good work around but created another problem.
So the only thing in the table is the SS # -

So if I can't fix my original problem how can I tell the table to convert
the SS # field to update the Last Name + First Name field ?

--
HTH - RuralGuy (RG for short) acXP WinXP Pro
Please post back to this forum so all may benefit.

Message posted via http://www.accessmonster.com