Loop in access 2010 macro

[rkmaitra]

Hello,
I am trying to create a macro to loop through all the records in a form and replace a number field until it hits a record with a specific entry.
I am unable to find the command in the macro drop-down box. The command I am looking for is Do Until.
I would prefer to work through macros rather than in VBA as I don't know how to program using VBA.
Please help.
Thank You,
Rudra

 

[Galaxiom]

If it isn't in the macro builder then I think you probably need to use the VBA. Take the plunge and you won't regret it.

Coding isn't as hard as it first appears and you will soon get the hang of it. In some ways it is easier to use than macros and it has the advantage that its power is virtually unlimited.

 

[Chad-M]

I would agree with GalaxiomAtHome.
It is quite easy to learn VBA and the help system pretty much gives you what you need to make your modules, if not then the internet can always give you what you need.

You are right with the Do Until statement so have a go making your own macro. Hint;

Sub FirstMacro ()
Dim sRecord as String

Do Until sRecord = "stop"
' statements here
Loop
End Sub