last record as default for new

[Marrick]

This code is very handy for setting the default value for the next record...
controlnameX.DefaultValue= """"controlnameX""""
But I have never understood why 4 sets of quotes are required on either side of the control name.
Any enlightenment on this feature much appreciated

 

[vbaInet]

I think you mean:

controlnameX.DefaultValue= """" & controlnameX & """"

Or

controlnameX.DefaultValue= """somevalue"""

So the first one is four quotes and a concatenated value from a control, while the second one is simply a text value using three quotes.

The result must be surrounded in quotes because the Default Value is strict on this, so this is how the compiler expects you write it.