By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
437,673 Members | 1,653 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 437,673 IT Pros & Developers. It's quick & easy.

Repeat value of previous record field into current corresponging field

P: n/a
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
Nov 13 '05 #1
Share this Question
Share on Google+
4 Replies


P: n/a
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
Nov 13 '05 #2

P: n/a
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
Nov 13 '05 #3

P: n/a
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.
Nov 13 '05 #4

P: n/a
jv
same concept, except with # signs
theValue.defaultvalue = "#" & theValue.value & "#"

Nov 13 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.