repeat previously entered information?

[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.

 

[StCyrM]

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

 

[Linda]

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.

.

 

[Craig]

Nadine,
This is the easiest way. Press CTRL+APOSTROPHE (').
No code is needed.
--Craig