Concatenate records into single query

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

re: Concatenate records into single query

perryche@yahoo.com wrote: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

re: Concatenate records into single query

On 15 Jul 2006 15:17:15 -0700, perryche@yahoo.com wrote:
*****I assume you mean combobox2 here

if team2 is chosen, onlyYou 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

re: Concatenate records into single query

you mean something like this?

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

re: Concatenate records into single query

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.


pietlinden@hotmail.com wrote: