ComboBox and Tables.

[Guest]

I have a combo box that finds a name and text boxes that fill in based on
that name. What I need is for all that information to be added to a table
and a mail merge along with information that is manaully entered in the rest
of the form. HELP!

 

[Kgwill85]

I have a combo box that finds a name and text boxes that fill in based on
that name. What I need is for all that information to be added to a table
and a mail merge along with information that is manaully entered in the rest
of the form. HELP!

I have the same question.

*patiently awaits reply*

 

[Jeff Boyce]

David

If I'm understanding, no you don't! If the data is already stored in one
table, don't redundantly store it again. Instead, use a query to look it up
when you need it.

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Guest]

Jeff,
I have a table that pulls REp names, CUIDs Managers, Area managers. After I
find this rep name in the drop down box I need all that information entered
to another (different) table. I can get the Rep Name to enter the different
table but none of the other information is making it to the table.
The secord talbe will be holding more information that the user enters on
the form where my drop down information is.

 

[Guest]

David

If I'm understanding, no you don't! If the data is already stored in one
table, don't redundantly store it again. Instead, use a query to look it up
when you need it.

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Jeff Boyce]

David

"Thinking relationally" (e.g., using Access) is not the same as using Excel.

You most certainly do NOT need to copy the data over (redundantly) to
another table. In fact, doing so will lead to any number of problems in the
future, such as synchronization.

Instead, store only the RepID (not even the rep name -- 'cuz what will you
do when there are two 'John Smith's'?

Then use a query to 'get' the related information you have been trying to
(redundantly) store.

Consider posting further description of WHY you want to store that data a
second time ... what would having that data allow you and your users to do?

Regards

Jeff Boyce
Microsoft Office/Access MVP