N
nkstrou
Hi All -
I'm fairly new to Access programming, and I'm having a strange problem with
Nav button controls on my db. (I'm just using the default Access nav buttons)
. I'm using Access 2003 on Windows XP.
The UI to my app consists of a form with a subform. The subform has 8 second-
level subforms, only 0 or 1 of which should be visible when any given record
is active. Each of the 8 second-level subforms exists on a separate tab, and
each has a single third-level subform. I've disabled the Nav Buttons on all 8
third-level subforms, because each record in the 2nd level subform should
have only 1 related record in the 3rd level subform, but I leave the Nav
Buttons on for the main form, subform, and the 8 second-level subforms.
The problem I'm having is that when I open either the main form or the
subform in Form view, the nav buttons for the 2nd level subform don't work,
but if I open any one of the 2nd level subforms by itself, they do.
I have set the appropriate Master/Child links and know they are working
because I see the correct number of records for each 2nd level subform.
I've checked the AllowAdditions/AllowEdits properties on all the forms and
those are all set to Yes.
I've tried removing the 2nd level subform from its tab and re-adding it in
the hope that would reset whatever is broken, but that didn't fix it. I've
confirmed Enabled is set to Yes for all forms, and Cycle is set to All
Records.
I tried a repair/compact, no luck.
I even tried creating a new .mdb file and reimporting everything, still no
luck.
I know that the Nav buttons trigger the Current event, and I do have code
running for the Current event of the 1st level subform, but all that does is
make the appropriate tab visible and hide/unhide a couple of buttons.
At this point, I'm out of ideas and would appreciate any suggestions any of
you experts out there might have.
Many thanks,
nkstrou
I'm fairly new to Access programming, and I'm having a strange problem with
Nav button controls on my db. (I'm just using the default Access nav buttons)
. I'm using Access 2003 on Windows XP.
The UI to my app consists of a form with a subform. The subform has 8 second-
level subforms, only 0 or 1 of which should be visible when any given record
is active. Each of the 8 second-level subforms exists on a separate tab, and
each has a single third-level subform. I've disabled the Nav Buttons on all 8
third-level subforms, because each record in the 2nd level subform should
have only 1 related record in the 3rd level subform, but I leave the Nav
Buttons on for the main form, subform, and the 8 second-level subforms.
The problem I'm having is that when I open either the main form or the
subform in Form view, the nav buttons for the 2nd level subform don't work,
but if I open any one of the 2nd level subforms by itself, they do.
I have set the appropriate Master/Child links and know they are working
because I see the correct number of records for each 2nd level subform.
I've checked the AllowAdditions/AllowEdits properties on all the forms and
those are all set to Yes.
I've tried removing the 2nd level subform from its tab and re-adding it in
the hope that would reset whatever is broken, but that didn't fix it. I've
confirmed Enabled is set to Yes for all forms, and Cycle is set to All
Records.
I tried a repair/compact, no luck.
I even tried creating a new .mdb file and reimporting everything, still no
luck.
I know that the Nav buttons trigger the Current event, and I do have code
running for the Current event of the 1st level subform, but all that does is
make the appropriate tab visible and hide/unhide a couple of buttons.
At this point, I'm out of ideas and would appreciate any suggestions any of
you experts out there might have.
Many thanks,
nkstrou