Forms: Carry current value of a control to new records

(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

'******** Code Start **********
    const cQuote=""""    'Thats two quotes
    me!Control.DefaultValue = cQuote & me!Control.Value & cQuote
'******** Code End **********

    would carry the current value of the control forward if you place this code behind a command button to conditionally run it.