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

Tables do not have triggers [events].

Why are you posting this in the Visual Basic section of the forum and not in one of the many Access sections?