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!

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;

"Kevin" <(E-Mail Removed)> wrote in message
news:1553F6CA-B8BF-4BD7-8D75-(E-Mail Removed)...
>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!