PDA

View Full Version : Access 2000 Macro Loops



03-10-2001, 12:04 AM
I am trying to write a macro that runs a macro inside itself.

The inside macro is designed to check data in a table in form view and display a message that the data complies with true or false message.

The part I am having trouble with is the runmacro function in that I cant get it to jump to the next record and display the results of that record. As a result the macro freezes on the first record and won?t open the next record in form view.

I am only very new at this sort of thing and trying to learn more.
Any help or comments will be gratefully appreciated.

Terry

03-10-2001, 08:51 AM
To call a macro from within another macro use the command Application.Run 'Book1!Macro1'

When debugging a macro it is often useful to step through a macro as it is running. Press F8 to step to the next line.

Make sure that the second macro being called has ended before it is called again, forming an infinite loop.