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

Update or CancelUpdate without AddNew or Edit Error

P: n/a
I have a form that has the navigation buttons enabled. I have a
procedure that runs every time a new record is loaded (Current Event).
This procedure performs a SELECT from a table (different from the one
that serves as a source to the form) so that I can prepopulate the
values of an unbound list box. I am getting this error:
Update or CancelUpdate without AddNew or Edit

Please help.

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


P: n/a
JSMiami wrote:
I have a form that has the navigation buttons enabled. I have a
procedure that runs every time a new record is loaded (Current Event).
This procedure performs a SELECT from a table (different from the one
that serves as a source to the form) so that I can prepopulate the
values of an unbound list box. I am getting this error:
Update or CancelUpdate without AddNew or Edit

Please help.

Thanks


I had a similar problem earlier. I added the code line
msgbox "Dirty " & Me.Dirty
into the OnCurrent event. Sure enough, something I had done had set the
code to dirty. So I removed that line and entered
If Me.Dirty then DOcmd.RunCommand accmdsaverecord
in the OnCurrent event and the error went away.
Nov 12 '05 #2

P: n/a
It worked but I'm not sure why. I didn't remove any code as you
indicated but I did add the code mentioned. Very weird but I
appreciate the response. Thanks!
Salad <oi*@vinegar.com> wrote in message news:<T_******************@newsread1.news.pas.eart hlink.net>...
JSMiami wrote:
I have a form that has the navigation buttons enabled. I have a
procedure that runs every time a new record is loaded (Current Event).
This procedure performs a SELECT from a table (different from the one
that serves as a source to the form) so that I can prepopulate the
values of an unbound list box. I am getting this error:
Update or CancelUpdate without AddNew or Edit

Please help.

Thanks


I had a similar problem earlier. I added the code line
msgbox "Dirty " & Me.Dirty
into the OnCurrent event. Sure enough, something I had done had set the
code to dirty. So I removed that line and entered
If Me.Dirty then DOcmd.RunCommand accmdsaverecord
in the OnCurrent event and the error went away.

Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.