Mass Change from Form

[Jaro19a]

Is there away to change a feild for a group of people form a form.

So the Table would look like this.

Name | Group | Status
---------------------------------------
Tim Smith | Youth | Out
Jake Smith | Youth | In
Nick Smith | Adult | Out

But after you slected the new status for all youth in a combo box in a form and clicked ok. The table would look like this.

Name | Group | Status
---------------------------------------
Tim Smith | Youth | New
Jake Smith | Youth | New
Nick Smith | Adult | Out

If you can help please let me know.

 

[Rob.Mills]

Are you familiar with using Update queries? That would be what you want to use.

 

[Jaro19a]

Well I'm still new to the deep stuff in access. I can do queries, but I'm unsure what a Update queries is. Can you help me with a URL, or a sample?

Thank you,
Jeremy

 

[Rob.Mills]

I've attached some screen prints of the steps to set one up. You can also learn a lot about the different kinds of queries in the help file.

 

[Jaro19a]

Thank you for your help. It work great.