Trigger for UPDATE

[ChrisBeach]

Hi all, I have an access front end, and I need to prevent the user from updating data in a subform if the date is before a certain time.. I have a trigger for inserts and deletes.. selecting the date from the inserted or deleted table, but not quite sure how to go about this for an update, anyone have any ideas?

 

[cmmrfrds]

I don't know if you got an answer on this yet, but an update is both a delete and insert so both of these tables are available on an update.

 

[ChrisBeach]

I did finally end up finding it, i should of posted on here that I found an answer, but thanks for posting, I really appreciate it =)