Forum Home
Press F1
 
Thread ID: 11688 2001-10-02 12:04:00 Access 2000 Macro Loops Guest (0) Press F1
Post ID Timestamp Content User
19856 2001-10-02 12:04:00 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
Guest (0)
19857 2001-10-02 20:51:00 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.
Guest (0)
1