Update multiple table rows from form with single entry

[Justinidea]

Hi Y'all

I have a table with multiple rows for specific groups, something like this:

ID	Group	Subgroup	User
2	blue	A123	Me
3	blue	A234	Me
4	blue	A345	Me
5	blue	A456	Me
6	green	B567
7	green	B687
8	green	B891
9	green	B912
10	green	B124

<colgroup><col style="width: 48pt;" span="4" width="64">
<tbody>


</tbody>

I want to update the User field for all the "blue" records by entering "me" in a form only once.
like this

Group	blue
User	Me

<colgroup><col style="width: 48pt;" span="2" width="64">
<tbody>


</tbody>

Obviously there are more fields in the table. Also I cannot build a relational table of group and subgroup because my data is not constant. Sometimes "blue" might have three subgroups, sometimes it might have 20 subgroups.

Any suggestions will be greatly appreciated.

I have a vague idea that I might have to use the form to create a new table then run an update query, but I'm thinking there might be a more direct and "elegant" way to accomplish this.

Thanks!

 

[Justinidea]

I waited too long to edit that last paragraph - I should have said that the form must update the original table to find all the "blue" group lines, so I'm not sure if I can create a new table from the form.
I'm gonna keep working on it, but I hope someone can give me an answer... thanks again.

 

[Justinidea]

Ok, I think I found the answer - http://www.mrexcel.com/forum/microsoft-access/685213-create-form-update-query.html

It took a while, but this will work.