one field on form to update several

[quackslikeaduck]

Can I use one field on a form to update 5 different records with 1 single value? or can I create a query that does this and point the 1 field on form to the query?

For instance: I want to see one field on the form called "Price". I want the value of whatever is entered into that field to update the table with records "Price1, Price2, Price3" with that single value. That way a user will not have to enter for all of them but just for one.
Thanks!

 

[dhookom]

You could use code to run an update query. Do you really want to update "5 different records" when your further text "Price1, Price2, Price3" suggests multiple fields in one record?

Can you provide some additional context to what you are attempting to do? How about providing actual table and field names?


Duane
Hook'D on Access
MS Access MVP