Mr. Lebans or anyone: Help with subform navigation

[Guest]

Mr. Lebans,
I have downloaded and used your navigation subform example in an application
I have developed. I did convert it to access 2000, which is what my App is
written with.

Here is my question:
It works fantastic with the navigation form as a subform on another
form...just as the example shows. I want to use is it one level deeper
though. I have a Mainform that has one subform. I want to use your navigation
subform on my subform.

I am not sure if I am being clear here, is sounds like a lot of subforms,
but basically it is a MainForm with SubformA. I want your navigation to be a
subform on my SubformA. When I try this it gives me the error...â€SubformA is
not Openâ€.

I know it has something to do with the DoCmd action where the object name is
required.
I have tried all sorts of different methods, but my understanding of how to
do this is beyond my current skill level.

Any help from anyone would be appreciated.

Mike Robinson

 

[Stephen Lebans]

Oh...what a headache...too many levels!
Mike I believe someone asked this very same question over the last year and
perhaps there was a solution in that thread as well. Have you searched
GoogleGroups on this issue?
Try keywords such as:
lebans subform nav

Let me know.
--

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

 

[Guest]

Stephen,
Thanks for the more than promt reply. I have not searched Google but I will.
If I find anything there I will post it under my original post. I can work
around this with no problem, but the "canned" subform navigation was so neat
that I had to try, and still will.

Thanks a million for your reply on this and so many others!

Mike Robinson

 

[Graham Mandeno]

Hi Mike

I have made some modifications to Stephen's code so that it will work with
subforms and even with the nav subform on a different form. He has posted
it on his site at http://www.lebans.com/recnavbuttons.htm.

Note that it will only work on A2000 or higher, because it uses the form's
Recordset property.