drop down list to fill in blanks

N

Nikki

Hi,

I have created a continuous form called 'History' that I would like to have
one of the fields a drop down combo box on a form that has a list of the
users that are in a table called 'Employees' with the field called 'User'. I
would like to be able to select the User from this list and then have the
form automatically enter the corresonding 'Team' which is a field also in the
table 'Employees'.

Can someone please help me with this?

Thanks
 
S

strive4peace

Hi Nikki,

I am assuming that the combo is collecting an ID of some sort? Maybe
UserID? And that is bound to a field in your current RecordSet? And
that UserID is defined in the Employees table? And that Team (or
TeamID) is also stored in the Employees table?

If that is the case, why do you want to store team somewhere else? It
is not necessary.

to help you understand a bit better, send me an email and request my
30-page Word document on Access Basics (for Programming) -- it doesn't
cover VBA, but prepares you for it because it covers essentials in Access.

Be sure to put "Access Basics" in the subject line so that I see your
message...

Warm Regards,
Crystal
*
:) have an awesome day :)
*
MVP Access
Remote Programming and Training
strive4peace2006 at yahoo.com
*
 
Top