Object Not Open AfterAdding Leban Navigation Buttons To Subform

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I used Steve's custom nav buttons on my form and they work great! Thanks Steve! I also wanted to add then to my subform which is linked to the main form with "IDClientNo". If you open up the subform by ityself, the buttons work great, just like on the main form. But when I open the main form with the embedded subform and try to navigate the navigation buttons on the subform, I get the error "The Object "Subform" isn't Open". I've tried just about everything and checked to make sure this was caused by the addition of the nav buttons in the sub. I'm sure someone has a simple fix?
 
Hi Lisa,
that solution was hardcoded to work only when the parent object is a
Form not a SubForm. The quickest solution is to simply copy and paste
the controls and code onto your SubForm.
I shoudl go back and fix the NavButtons solution to work on a Form or
SubForm but honestly, I hate working with Form/Subform issues as they
are a pain to debug!
:-)

--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.


Lisa said:
I used Steve's custom nav buttons on my form and they work great!
Click to expand...
Thanks Steve! I also wanted to add then to my subform which is linked to
the main form with "IDClientNo". If you open up the subform by ityself,
the buttons work great, just like on the main form. But when I open the
main form with the embedded subform and try to navigate the navigation
buttons on the subform, I get the error "The Object "Subform" isn't
Open". I've tried just about everything and checked to make sure this
was caused by the addition of the nav buttons in the sub. I'm sure
someone has a simple fix?
 
Thanks Steve.That's kind of what I though but wasn't sure. One other questions though. Is is necessary to have the hidden text to get the focus. The tiny control kept beiing visible so I deleted it and commented out the setfocus statement. Any problems with doing this? Thanks.
 
As far as I remember you absolutely must keep that tiny TextBox control
because of Form/SubForm/SubForm control focus issues. Were you still
receiving the error message before you deleted the control.

--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.


Lisa said:
Thanks Steve.That's kind of what I though but wasn't sure. One other
Click to expand...
questions though. Is is necessary to have the hidden text to get the
focus. The tiny control kept beiing visible so I deleted it and
commented out the setfocus statement. Any problems with doing this?
Thanks.
 
No. I deleted the hidden control and remmed out (') the SetFocus statement that referrend to the hiddentext. . No errors are being encountered so I thought everything is a OK, For what it is worth, I'm using Access2003.
 
Back
Top