F
forrest lyman via AccessMonster.com
i use three levels of forms in my application.
[main] > application logo, main navigation buttons
[subform1] > specific control buttons, user tips
[subform2] > datasheet
i do this to separate my format, controls, and data
i am having a problem with my controls on [subform1].
[subform1] includes the navigation buttons for [subform2], as well as a search function, etc.
when i test [subform1] alone all of the controls function as planned.
when i nest the completed [subform1] in [main] the navigation controls on [subform1] stop working with [subform2].
all of the rest of the controls continue to work (search function, etc.).
i have tried every method i have found of referencing the nested subform, but can't get the nav buttons to work. the cursor stays in the first field of the first record. what is even more confusing is that i disabled my error handler on the nav button code while debugging, and while the cursor is not moving vba appears to think it is. after cycling through the sample files i get the "you can not go to the specified record" error.
i have tried to use vbconstants
DoCmd.GoToRecord , , acNext
as well as pointing directly to the record i want
DoCmd.GoToRecord , , 4
is there a dao or ado solution?
[main] > application logo, main navigation buttons
[subform1] > specific control buttons, user tips
[subform2] > datasheet
i do this to separate my format, controls, and data
i am having a problem with my controls on [subform1].
[subform1] includes the navigation buttons for [subform2], as well as a search function, etc.
when i test [subform1] alone all of the controls function as planned.
when i nest the completed [subform1] in [main] the navigation controls on [subform1] stop working with [subform2].
all of the rest of the controls continue to work (search function, etc.).
i have tried every method i have found of referencing the nested subform, but can't get the nav buttons to work. the cursor stays in the first field of the first record. what is even more confusing is that i disabled my error handler on the nav button code while debugging, and while the cursor is not moving vba appears to think it is. after cycling through the sample files i get the "you can not go to the specified record" error.
i have tried to use vbconstants
DoCmd.GoToRecord , , acNext
as well as pointing directly to the record i want
DoCmd.GoToRecord , , 4
is there a dao or ado solution?