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

Detect When Entering New Record

P: n/a
MIG
Is there a way that, when using a single or continuous form which
allows additions and edits, I can detect when I am entering a new
record (eg moved on to *) rather than editing an existing one?

In general, while wanting edits to be allowed, I want to be able to
warn if certain fields are being edited unexpectedly, but not do this
while a new record is being entered.

It's to avoid the sort of situation where someone thinks they are doing
a filter by form but accidentally types all over an existing record (is
it only me that people do this to?).

Nov 13 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
On 2 Nov 2005 03:00:30 -0800, "MIG" <go********@doreenbird.co.uk> wrote:
Is there a way that, when using a single or continuous form which
allows additions and edits, I can detect when I am entering a new
record (eg moved on to *) rather than editing an existing one?

In general, while wanting edits to be allowed, I want to be able to
warn if certain fields are being edited unexpectedly, but not do this
while a new record is being entered.

It's to avoid the sort of situation where someone thinks they are doing
a filter by form but accidentally types all over an existing record (is
it only me that people do this to?).


IF Not Me.New Record Then (existing record)

IF Me.NewRecord Then (new record)
Nov 13 '05 #2

P: n/a
MIG

Wayne Gillespie wrote:
On 2 Nov 2005 03:00:30 -0800, "MIG" <go********@doreenbird.co.uk> wrote:
Is there a way that, when using a single or continuous form which
allows additions and edits, I can detect when I am entering a new
record (eg moved on to *) rather than editing an existing one?

In general, while wanting edits to be allowed, I want to be able to
warn if certain fields are being edited unexpectedly, but not do this
while a new record is being entered.

It's to avoid the sort of situation where someone thinks they are doing
a filter by form but accidentally types all over an existing record (is
it only me that people do this to?).


IF Not Me.New Record Then (existing record)

IF Me.NewRecord Then (new record)

Aha; thanks.

(As a last resort, try the bleedin obvious, but I never spotted that.)

Nov 13 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.