Procedure Question

[apartain]

Since I don't know VBA very well, I have always used wizards and macros to create my databases.

I have created a button which opens a form to view a specific record. I created the button with a wizard, and in the button's OnClick property it reads

[Event Procedure]

obviously.

But, now I am creating a macro which needs to run the same event procedure and can't figure out how to reference it.

Can I do this without the use of VBA?

Please see Screen shot
Thank you.

[MMcCarthy]

Since I don't know VBA very well, I have always used wizards and macros to create my databases.

I have created a button which opens a form to view a specific record. I created the button with a wizard, and in the button's OnClick property it reads [code][Event Procedure][code] obviously.

But, now I am creating a macro which needs to run the same event procedure and can't figure out how to reference it.

Can I do this without the use of VBA?

Please see Screen shot
Thank you.

You can run code in a macro like a function. However, you can't get a macro to run an event procedure to the best of my knowledge (I haven't used macros in years). This is because event procedures are based on form events.

What are you using the macro for. Maybe we can suggest some vba code to replace it which could run the event.

[apartain]

I have a query which only shows transactions for the current week. If a change is made to a transaction, I need to go to through all of the transactions for the whole week, which shouldn't be more than 10 or so, and update each by running a macro because the result of one changed transaction will change the status of the other transactions in the query.

I was planning on (via macro) using GoToRecord, running the macro which opens the form filtered for that transaction record (which is the part I have a question about), running another macro which performs several very touchy calculations from bound and unbound fields on that form, then running the macro which updates some other fields and saves the records and closes the form, then repeating the macro again for the next record until all records have been updated.

Does that even make a little bit of sense?

Sorry to be confusing.

[NeoPa]

It does make sense.
However, it sounds as if there may well be a better way of storing your information.
I can't be sure because I don't have all the details, but generally, when you need to update many records, based on the change of one piece of data then the data is not stored optimally.