Trigger/XML

Hi,

1. How can I execute a Trigger on an Access table on an UPDATE (on a specified field), using VBA/SQL?

2. I then need to produce/export a XML document from the table (or tables using a one-to-many relationship), how do I do this?
Note: This has to be performed on the UPDATE.

EXAMPLE:

Table_A
Field1 = Order Number
Field2 = Status field (when Updated to ‘C’)

Table_B
Field1 = Order Number
Field2 = Line Number

Thanks in advance,

Neal

Welcome to the Forums.

Access does not support triggers.

If you are updating the record via code like a .Update call then you can just write your XML file out after.