Repeat an action

J

jeanulrich00

Hi

I have a form link to a table

One field is named [Avancement] and another is [01]

I have had a command button and behind the following script

Dim xt As String
xt = [Forms]![F-Avancement0]![Text334]
[xt] = [Avancement]
End Sub

If the active field is on record N°1 and I click the command button
field [01] is updated to field [Avancement]

What I want to do is that if I click on the button, ALL records field
[01] would be updated to field [Avancement]

thanks
 
Top