Run a macro on a record save

[guitardave78]

Hi all.
I want torun a macro to create a new id (first 3 letters of the surname + 001 etc any ideas on best way to do that welcome!!)

My big problem is how do i run the vba function when I save a record. I keep having to focus to the id field on the form which disrupts things!!

ANy ideas as I know this is really simple!

}...the bane of my life!

http://www.yetanotherreviewsite.co.uk

http://www.fuzzyd.co.uk

 

[Remou]

Does it have to be a macro? A little code in the before update event of the form would work quite nicely.