combobox data from another table

  • Thread starter Thread starter JohnE
  • Start date Start date
J

JohnE

I am at wits end. I have a database with hundreds of
clients each with a unique ID. As each client goes thru
an implementation process, a team is selected and listed
on a form (usrfrmTeamMembers). This is a continuous
form. The clientID is also used on the form. The team
members are stored on a table (usrtblTeamMembers) along
with the clientID. This table will have many names the
same but the clientID would be used once for each team
member. After the team is selected, there are a series
of processes that they need to go thru. Each of these
processes is a different form. On each of the process
forms there is a combobox that I would like to have
populated with only the names of the team selected for
the client. The clientID is a field on each of the
process forms. This combo is for selecting the team
member who is responsible for that process. I am having
trouble getting the combo to populate with only those
names of team members selected for that client.
Thanks in advance to anyone that has any thoughts on this.
*** JohnE
 
you could do this by creating a form with a subform containing the separate
team members and all the fields required for your needs and the teamID in
the main form

call this form by double clicking on the teamID in your client form or with
a command button or whatever

make this teamid form open with the current teamID in the client's form as
linkcriteria (take a look at the docmd.openform and it's parameters)

bon chance
 
Back
Top