Runtime-Error 40036

  • Thread starter Thread starter Mark Seaborn
  • Start date Start date
M

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?
 
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?
 
Mark Seaborn said:
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?
Click to expand...

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
 
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. :-)
 
Back
Top