Running a Macro from another form

[pbennison]

Hi,

I have 2 forms and a macro in Form1 which runs throught every record to update the records, however..

I would like to run this macro from the main form (Form2)

I have tried
docmd.openform "Form1"
Run Macro

but it doesnt work:banghead:

Any ideas ??

Thanks

 

[pr2-eugin]

What does the macro do again? Why don't you use a Simple Update Query, instead of looping through the records in the form?

 

[pbennison]

I have lots of textboxes that are update through a macro which is run when the record is opened.
Its not just this though i want to have a form which has buttons which will run various macros .
I figured that i should be able to call any macro from any place ?
Is this possible ??

 

[pr2-eugin]

Huh ? I am totally confused !

 

[jdraw]

pbennison,
We(readers) are confused.
You have told use a little about your issue, but can you tell us a little more info about WHAT you're doing in plain English business terms?

As for

is this possible?

, we used to say anything is possible. It's just SMOP which requires a lot of details.

SMOP -- small matter of programming