Change field value in many records?

[Kevin]

I have a particular field on the end of one-to-many relationships with a
default value of 1.25. I’d like to create a way for users to be able to
enter a different value into a control on a subform, 1.22 as an example, and
then click a button or something and it would change all records within that
relationship to the 1.22 value.

The relationships are as follows:
tblBid has a field BidNumber
tblItem has 2 primary keys - RoomNumber & ItemNumber, this is on the many
side of relationships to the field BidNumber
tblItemDetail is on the many side of a relationship to tblItem, this is
where the field MarkUp exists with the default value 1.25

The end goal is to be able to enter a desired value of the MarkUp field in
one location, and have it update the value in all of the records associated
with one BidNumber. Where do I start with something like this? An update
query, a macro, etc.?
Any help is appreciated!

 

[Pat Hartman\(MVP\)]

Run an update query. If you only want to change the records with the
default value, be sure to include that field in the criteria as well:

Where KeyField = Forms!yourForm!KeyField AND Markup = 1.25;