Updating Multiple Records at once

Updating Multiple Records at once

Ok, heres the scenario...
2 Forms...
Form A
Form B
They share a common field, Location, that is filled in on both forms
Form A has a field called Pyramid
How do i bring in the data in the Pyramid field from form A to fill in the matching Location in form B

I know i need a for each record command, but im struggling to write it, thanks