Last record info copied into the new record

  • Thread starter Thread starter Geo
  • Start date Start date
G

Geo

I have four fields, one is a combo box. I want two of the
text fields to copy/remember the information in the
previous record entered. How do I go about doing that.

Thanks,

Geo
 
Hi Geo

The following should work for you..




Const cQuote = """"

'Carry values forward
Me!txtField1.DefaultValue =cQuote & Me!txtField1.Value & cQuote

Me!txtField2.DefaultValue = cQuote & Me!txtField2.Value & cQuote

Me!txtField3.DefaultValue = cQuote & Me!txtField3.Value & cQuote

Me!txtField4.DefaultValue = cQuote & Me!txtField4.Value & cQuote

DoCmd.RunCommand acCmdRecordsGoToNew
 
Back
Top