You will find almost everyone here prefers VBA. It gives you much more versatile control over what is being done, permits single-stepping through the code to examine what is taking place, and is the only way to incorporate error handling.
It is a useful tool from time-to-time to create a macro then convert it to a procedure, causing Access to reveal the VBA code that does what the macro was written to do. This can be pretty educational!
You cannot loop through records with a macro, so if you need to do that, you are really painted into the VBA corner--itâs your only option.
|
Macros vs VB
