Hi Mumps
Thanks for your help, that worked a treat. However...
Also the code that puts data from the UserForm to the table is slow (discovered as I walked through you code - which is much faster finding the new row).
The Userform as about 7 bits of information, ranging from simple Textbox to ComboBox and DTPicker.
I use code:
etc etc
Again this used to be a little quicker, is it purely the amount of data, or is there some kind of memory dump I need to do in VBA?