Trigger on Open....
Is there any way to trigger actions on open a record? (there are on create and on update)
Background: I am implementing a "cancel / undo" option where I want to rollback the values in case of undo/cancel....
I am basically creating a duplicate record with a "backup" but I was looking forward to having a more elegant option....
RoSoft_Steven This is a good idea, as I have longed since wanted an event to trigger on OpenForm or CloseForm (without having to update something)
Your idea works on all tabs after the main page on the form. However this replies on triggering that tab. Ideally I want it on the main first page, which of course by default the tab shown is the form name itself and you can't append a trigger before view on ... aha I though - I know I will create a tab and drag it all the way to the top of the edit list and append the trigger to that tab.
Great I can add the simple script (DisplayMenu := 1) Nope it don't work (unless I exit the db and then go back in)
Only works on 2nd tab and after
RoSoft_Steven No mate- on the first tab it won't trigger unless as stated you go in firm (not worked
exit then go in again (works) same for every record
also tried to ur script on global - but its not having it (probably trying to do it wrong tho...)
see sample (set it to alter MODdate cell to today)
so open form (nothing)
close the form\
Hey presto (works)
No form update taken place! other than the trigger to set today in ModDate
as you can see I added a tab to replace the main form name
Form is called JobDockets by default (new tab Main)
so close but .......