Connecting Tech Pros Worldwide Forums | Help | Site Map

Form error: "Update or CancelUpdate..." etc.

NewDBGirl
Guest
 
Posts: n/a
#1: Nov 12 '05
I have a multiple-page form for entering info about a project with several
sub-forms for sub-projects, notes and tasks. The form and one of the
sub-forms each have a combo box to select a record to display, as well as
a "last date/time updated" type of field that populates AfterUpdate.

What can I do to fix the "Update or CancelUpdate without AddNew or Edit"
error? I'm pretty unschooled in code but I have gotten by with macros and
cut-and-paste so far. :)

Thanks!


Trevor Best
Guest
 
Posts: n/a
#2: Nov 12 '05

re: Form error: "Update or CancelUpdate..." etc.


NewDBGirl wrote:
[color=blue]
> I have a multiple-page form for entering info about a project with several
> sub-forms for sub-projects, notes and tasks. The form and one of the
> sub-forms each have a combo box to select a record to display, as well as
> a "last date/time updated" type of field that populates AfterUpdate.
>
> What can I do to fix the "Update or CancelUpdate without AddNew or Edit"
> error? I'm pretty unschooled in code but I have gotten by with macros and
> cut-and-paste so far. :)
>
> Thanks!
>[/color]

I had the same thing here http://tinyurl.com/38mme, if yours isn't as
bad as mine the links in my post there may help you.

--
Error reading sig - A)bort R)etry I)nfluence with large hammer
Bob Quintal
Guest
 
Posts: n/a
#3: Nov 12 '05

re: Form error: "Update or CancelUpdate..." etc.


"NewDBGirl" <f.shireen@falsebit.nospam.hotmail.com> wrote in
news:dc181cd6fed8557141fbf092d3a175f9@localhost.ta lkaboutdatabase
s.com:
[color=blue]
> I have a multiple-page form for entering info about a project
> with several sub-forms for sub-projects, notes and tasks. The
> form and one of the sub-forms each have a combo box to select
> a record to display, as well as a "last date/time updated"
> type of field that populates AfterUpdate.
>
> What can I do to fix the "Update or CancelUpdate without
> AddNew or Edit" error? I'm pretty unschooled in code but I
> have gotten by with macros and cut-and-paste so far. :)
>
> Thanks!
>[/color]

Move the code that populates "last date/time updated" to the
BeforeUpdate event.

Bob Q

Closed Thread


Similar Microsoft Access / VBA bytes