Data Macro in Access 2010

[rkalapura]

I have a network database, using by many people in the company. I have data macros attached to the table and it was working fine until I split the database. I split the database and I sent all my tables to the back end, linked front end with back end tables. Now from the front end forms through command button, I am trying to run the data macros, it won't recognize. It gives a message that " Data macro does not exist". But when I go to the back end table and see, it is already there.

I have searched in the web and see that data macro wont work with linked tables. I assume that data macros assigned to a table of one database cannot be accessed from other database, even we create a link to that table. But this is the same database, we just split to back end and front end for some purpose.

Can anybody help me please. Am I doing something wrong here or missing to do something?

Thank you very much for assistance.

[RuralGuy]

Assuming all of the user access to your tables is through Forms then those Data Macros (table triggers) can probably be duplicated at the Form level.

[June7]

As RG says, use the equivalent Form events. Apparently Data Macros are intended for all-in-one design and web databases.

[rkalapura]

Thank you Rural Guy and June7 for assistance. As June7 suggested, I have to look for some form events for this.
God Bless You.

[RuralGuy]

A Form's BeforeUpdate event is a good place to trigger change events.