Grayed "After Events"

[eMel]

I'm trying to add macros to a table. I open the table and click the Table tab. I need to click the "After Update" but it is grayed out. How do I get it ungrayed?

Thank You,
eMel

 

[Galaxiom]

Tables don't support macros. They are for Forms and Reports only.

Users should not be interacting with tables.

 

[sneuberg]

In this thread it is written

If your existing database is a .mdb file with the 2000 or 2002-2003 format, you cannot create data macros on those tables. You can only create data macros on your tables if the database is using the .accdb file format. MDB files cannot understand data macros so those options are grayed out.

Could that be your problem?

 

[eMel]

Users aren't interacting with the tables. And they are linked. My problem is that I have a form in a form. When changes are made to the main form, they are written to an audit log. I'm using Emp ID for the first identifier. The subform doesn't have an Emp ID so it doesn't write the changes. Busy day so I didn't get to work on it. Tied up with keycodev2.dll issue on another project. Any form help appreciated.

Thank You!!

 

[Galaxiom]

Users aren't interacting with the tables.

Don't mind me. I only use mdb so didn't know about data macros. I expect Sneuberg is correct.

When changes are made to the main form, they are written to an audit log. I'm using Emp ID for the first identifier. The subform doesn't have an Emp ID so it doesn't write the changes.

Without knowing the details of your audit system it is hard to suggest.
Could you put EmpID in the subform and write it from the main form in the Current Event?

 

[eMel]

Good idea on adding Emp ID. I check.