repeat previously entered information?

  • Thread starter Thread starter Nadine
  • Start date Start date
N

Nadine

I would like to know if there is a way that when after
having finished entering the data on your form and that
when you create a new record that the data previously
entered is shown again on the form.

Actually only 3 field named fldHotel, fldMainContact and
fldPhone should be repeated each time when entering a new
record. TIA.
 
Hi Nadine

You can use the following to carry the values to the new record ...simply
substitute your field values


Const cQuote = """"

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

DoCmd.RunCommand acCmdRecordsGoToNew

Best regards

Maurice
 
I have tried that but that does not seem to work.
-----Original Message-----
Hi Nadine

You can use the following to carry the values to the new record ...simply
substitute your field values


Const cQuote = """"

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

DoCmd.RunCommand acCmdRecordsGoToNew

Best regards

Maurice


I would like to know if there is a way that when after
having finished entering the data on your form and that
when you create a new record that the data previously
entered is shown again on the form.

Actually only 3 field named fldHotel, fldMainContact and
fldPhone should be repeated each time when entering a new
record. TIA.
Click to expand...


.
Click to expand...
 
Back
Top