Repeat value of previous record field into current corresponging field

Something really common I'm sure and I'm surprised it's not just a field
property option.

The previous record's field value can be retrieved and copied into the
current corresponding field by the operator hitting CTRL+APOSTROPHE on the
new field but I would like this to occur with the user having to strike any
keys.

Suggestions?

Thanks,

Loren

[Bas Cost Budde]

lo*****@internet.com wrote:

Something really common I'm sure and I'm surprised it's not just a field
property option.

The previous record's field value can be retrieved and copied into the
current corresponding field by the operator hitting CTRL+APOSTROPHE on the
new field but I would like this to occur with the user having to strike any
keys.

It *is* a field property.

In the AfterUpdate event of the control (let's say it is called
theValue), put

theValue.defaultvalue = theValue.value

If theValue is text, do this:

theValue.defaultvalue = "'" & theValue.value & "'"

--
Bas Cost Budde, Holland
http://www.heuveltop.nl/BasCB/msac_index.html
I prefer human mail above automated so in my address
replace the queue with a tea

On Mon, 06 Dec 2004 08:11:42 +0100, Bas Cost Budde
<b.*********@heuvelqop.nl> wrote:

lo*****@internet.com wrote:

Something really common I'm sure and I'm surprised it's not just a field
property option.

The previous record's field value can be retrieved and copied into the
current corresponding field by the operator hitting CTRL+APOSTROPHE onthe
new field but I would like this to occur with the user having to strike any
keys.

It *is* a field property.

In the AfterUpdate event of the control (let's say it is called
theValue), put

theValue.defaultvalue = theValue.value

If theValue is text, do this:

theValue.defaultvalue = "'" & theValue.value & "'"

Ah yes, that did it!

Thank You very much.

LB

On Mon, 06 Dec 2004 16:36:24 -0600, <lo*****@internet.com> wrote:

On Mon, 06 Dec 2004 08:11:42 +0100, Bas Cost Budde
<b.*********@heuvelqop.nl> wrote:

lo*****@internet.com wrote:

Something really common I'm sure and I'm surprised it's not just a field
property option.

The previous record's field value can be retrieved and copied into the
current corresponding field by the operator hitting CTRL+APOSTROPHE on the
new field but I would like this to occur with the user having to strike any
keys.

It *is* a field property.

In the AfterUpdate event of the control (let's say it is called
theValue), put

theValue.defaultvalue = theValue.value

If theValue is text, do this:

theValue.defaultvalue = "'" & theValue.value & "'"

Ah yes, that did it!

Thank You very much.

LB

The above event/code worked fine for a text type control but not for a date
type. Can someone please tell me what to use to propagate a date field?

Thanks.

[jv]

same concept, except with # signs
theValue.defaultvalue = "#" & theValue.value & "#"