Concatenate records into single query

[perryche]

Hopefully this time someone can help me:
Table1: Employee (Employee Name & Team)

Form1: based on Table1 (for people to edit name and team; total 4
teams)

Form2: ComboBox1 with list of team to choose from. If team1 is chosen,
only team1 members are listed in ComboBox1, if team2 is chosen, only
team2 people are listed. (i.e. the source for ComboBox1 is based on a
concatenated result from Form1) e.g. Team1: Name1, Name2, Name3,
Name4; Team2: Name5, Name6, Name7... this becomes the drop list list
of this ComboBox!)

I understand how you can use Value List (however, I don't want to
programatically change the value list everytime an user has been added
or deleted.) I want it to base on a Concatenated query.

Hope you understand what I am after now. Thanks in advance.

Sincerely,
Perry

[Rick Brandt]

pe******@yahoo.com wrote:

Hopefully this time someone can help me:
Table1: Employee (Employee Name & Team)

Form1: based on Table1 (for people to edit name and team; total 4
teams)

Form2: ComboBox1 with list of team to choose from. If team1 is chosen,
only team1 members are listed in ComboBox1, if team2 is chosen, only
team2 people are listed. (i.e. the source for ComboBox1 is based on a
concatenated result from Form1) e.g. Team1: Name1, Name2, Name3,
Name4; Team2: Name5, Name6, Name7... this becomes the drop list list
of this ComboBox!)

I understand how you can use Value List (however, I don't want to
programatically change the value list everytime an user has been added
or deleted.) I want it to base on a Concatenated query.

Hope you understand what I am after now. Thanks in advance.

Sorry, makes little sense to me. How can a choice in ComboBox1 limit what team
members are listed in ComboBox1 (the same ComboBox)?

Did you mean to say that there are TWO ComboBoxes on Form2 and that you want the
second ComboBox to list the team members from the team selected in ComboBox1?
If not you'll have to try again with your explanation.
--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com

[polite person]

On 15 Jul 2006 15:17:15 -0700, pe******@yahoo.com wrote:

>Hopefully this time someone can help me:
Table1: Employee (Employee Name & Team)

Form1: based on Table1 (for people to edit name and team; total 4
teams)

Form2: ComboBox1 with list of team to choose from. If team1 is chosen,
only team1 members are listed in ComboBox1,

*****I assume you mean combobox2 here

if team2 is chosen, only

>team2 people are listed. (i.e. the source for ComboBox1 is based on a
concatenated result from Form1) e.g. Team1: Name1, Name2, Name3,
Name4; Team2: Name5, Name6, Name7... this becomes the drop list list
of this ComboBox!)

I understand how you can use Value List (however, I don't want to
programatically change the value list everytime an user has been added
or deleted.) I want it to base on a Concatenated query.

Hope you understand what I am after now. Thanks in advance.

Sincerely,
Perry

You wouldn't use a value list in the combo box, but a select query which gives just the members of
the selected team. eg

1. The rowsource of combobox2 is something like

select [Employee Name] from Table1 where Team = combobox1
2. In the afterupdate event of combobox1 you have

combobox2.requery

[pietlinden]

you mean something like this?

http://www.mvps.org/access/forms/frm0028.htm

[perryche]

For all that replied. I want to thank everyone of you. I found
something in the mvps.org that has a module and then use a query to
call for the code. It works beautifully. Thanks again.
pi********@hotmail.com wrote:

you mean something like this?

http://www.mvps.org/access/forms/frm0028.htm