Last record info copied into the new record

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
 
S

StCyrM

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Last Record Numbering 1
Access Form - Lock Fields from Editing 0
Access Automatically Send a notification email once a record is added 0
Populate field from previous record 0
GoToRecord on Split Form with Hidden Fields 0
Going to last record saved in list box 1
Adding new record in form/not pulling from combo 6
Making all controls match selection of combo box 0

Top