updating all records in a form

[skate]

I have a form (frmA)that displays the set of records continuously. When this form opens there is a field that bases it's display on values chosen in another form (frmB) that's open.
I have two problems. First, when frmA opens the displaying field is effected only on the record that has focus. I have to manually go thru all the records (give focus) for the field to update. HOw do I make it so the form opens with all records updated?
Secondly, with frmB open, if I change the values here, how do i update frmA? When frmA initially opens it takes the stored values of frmB, but then how do I do it such that it takes on the new values and updates?
I'm doing this project for work, so any help or quick responses would be greatly appreciated. Thanks!

 

[skate]

Ok, I figured out how to have my form update according to changes in another form, only problem is it only works on one record. Is there a way to have it run thru each record an update each?

 

[llkhoutx]

Build a DAO recordset and cycle through each record. alternatively, run a update query chaning each record.

 

[skate]

oh...I'm sorry, would you be able to tell me how to do that? I'm pretty new to access.