Runtime-Error 40036

[Mark Seaborn]

Ok, this is really frustrating and happens often. I am working on the code
for a sub form. Enter some vba code go back an start a form. At this point I
think the access database is corrupt or something. I cannot open particular
forms. Has anyone run into an issues where you can no longer use something
like
Forms.("Form1").Controls("subform1").Requery
to update a form? Instead you get runtime error 40036?

 

[Mark Seaborn]

Ok, I just reproduce the problem consistently. When I add the
Form_On_Key_Down() event procedure. It kills the form. No recovery from
this. Any ideas about that?

 

[Tony Toews]

Ok, I just reproduce the problem consistently. When I add the
Form_On_Key_Down() event procedure. It kills the form. No recovery from
this. Any ideas about that?

Searching on groups.google.com shows a few responses where the problem
is a typo in a control name. In one case ctl1 vs. ctl.

Dunno if this is your problem though.

Post your code for us to review.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm

 

[Mark Seaborn]

That is a good thought but the name is not changing. I can reference the
form just fine with the Forms("frmMain").Controls("frmSubform").Requery code
until I add the aforementioned Event handler through the properties event
tab. Oh well, guess I just won't do that any more and just use the key down
event procedure. That worked just fine. @#$$@!@$ Thanks for the input.