Multi-Record Append Query

[Guest]

Got a subform that displays records relating to sales generated by certain
agents (main form displays agents info). When the user enters a new value in
the subform, if the agent is a member of a team, I want it to add that sale
record to each member of the team. I was going to use an unbound control
that displayed the info, and an afterupdate event with if team = "" insert
into table values followed by an else statement to run an append query that
filtered by the team name in the currently select agent. Problem is that the
way I read the help file on the multi-record insert into statement, it looks
like it just adds records from another table, and i need it to add the same
values to a record for each agent on the team. Suggestions?

-eD

 

[Guest]

Was just re-reading my post and thought that an example might be better.

I've got John Smith and John Doe, members of Team John, and Anne Smith who
flies solo.

When I type in a new value to my dateunbound control, when John Smith's info
is displayed, I want the form to add a record for John Smith with that date,
and add a record for John Doe with that date, because they're both members of
team John.

When I type in a value for dateunbound when Anne Smith's info is displayed,
I just want it to add a record for Anne Smith. Suggestions?