Predifined text and starting from the last record(in a form)

[marko]

I don't know how to form my question but this is my problem:
I would like to fill out a form containing let's say 3 fields and then
when i go to the next record. Now the next record would be blank except
the last field wich would have the value of that same field from the
last record. How can i do that?
And when i start a form i would like to start if from the last
record(>* not the last but from a new,that would be the one after the
last which has values) not the first. How?
Thanks,

Marko

[pietlinden]

Forms: Carry current value of a control to new records
Author(s)
Dev Ashish
(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.

[marko]

Thanks for the answer but I'm pretty new at access so I don't know how
to work with VBA and i don't know how to put your answer in use. Sorry!
:(

Marko