Access equivalent of Approach Fill Field

[tagteam]

I am moving my user off an old Lotus Approach database to Access. They are very used to using Fill Field in Approach. It would allow you to find a set of records, then choose the field you want to update, then enter a value you want it set to and it would go and update that field for every record in the found set.

What is the best way to get an equivalent action in Access.

Here is what would happen:
User opens form


Users selects Filter By Form
Users gets back a found set of records
**User needs a way to update the lease end field for every record found

Thanks

[June7]

Requires VBA code. Options:

1. run an UPDATE sql action using the same filter criteria. Sample syntax:
CurrentDb.Execute "UPDATE tablename SET fieldname=" & Me.textboxname & " WHERE fieldname=" & criteria

2. cycle through records on form, this requires code that moves to each record and modifies value

[tagteam]

Thanks, however the current filter is done by the form, not by any filter criteria i have set so the Me.textboxname would be whatever field the user is clicked in. Not sure if access can use the active field as a variable.

Something like:
CurrentDb.Execute "Update currenttable set fieldname=" & Me.OnFocus & "Where fieldname=" & criteria

the vba code to move to the next record would be something like

Private Sub cmdUpdateFieldValue_Click()
    Dim rst As Recordset
On Error GoTo Err_cmdSetAll_Click
Set rst = Me.RecordsetClone
    With rst
       .MoveFirst
       Do 
          .Edit
        
           CurrentDb.Execute "Update currenttable set fieldname=" & Me.OnFocus & "Where fieldname=" & criteria
          .Movenext
       Loop Until .EOF
    End With
Exit_cmdSetAll_Click:
    Exit Sub
Err_cmdSetAll_Click:
    MsgBox Err.Description
    Resume Exit_cmdSetAll_Click
End Sub

[June7]

Not something I've ever tried.

Problem is, the field no longer has focus when user clicks the 'cmdUpdateFieldValue' button. The button has focus. So I think this gets terribly complicated with globally declared variables and setting the variables every time a data control gets focus and using the variables in the button procedure.

Why is there a need to do a mass edit like this? Why does changing value for one record need to be reflected in other records? How do you 'find a set of records'?