Uodate field on exit

[HDEvKev]

I need to update a field with the contents of 2 other fields when exiting a record. The fields (ItemNo) and (LotID) need to create or update the field (LotCode). ie: ItemID (GM-235), LotID (26) will result in LotCode (GM-235-26). I currectly use a Update Query that uses the expression: [products].[MasterPN] & "-" & [lotid] in the lotCode Field - "Update to". Unfortunatly, I am using a button on my form that executes the query, but it updates all the records and although it runs very fast, I would rather have it perform this task automatically when I leave the record. I hopes this makes sense. Any ideas?

 

[pbaldy]

http://allenbrowne.com/casu-14.html