(Q) How do I carry forward the current value of a control so that it's
automatically entered for all new records?
(A) To use the curent control value for new records, you need to assign
it to the defaultvalue of the control. For example something like
me!Control.DefaultValue = cQuote & me!Control.Value & cQuote
would carry the current value of the control forward if you place this
code behind a command button to conditionally run it.