good day experts,
I am here again seeking guidance..
I am planning to use key command combination in MACRO Builder in Access 2019.
I can't seem to find any in google or in this forum...
I am using Macro Builder and use gotocontrol to navigate my setfocus to another subform after pressing TAB and enter the corresponding entries.
in my main form, there are 2 subform. these 2 subforms are linked. Each record in subform1 has different datasheet entries in subform2.
My plan is in subform1, after the last field, when I press tab it will change focus to subform2 instead of going to the next record in subform1.
I was successful of running the code in changing the focus to the subform2 after pressing the tab, but the problem now is that it will display the datasheet for the next record of subform1.
Thank you in advance for the help...
I am here again seeking guidance..
I am planning to use key command combination in MACRO Builder in Access 2019.
I can't seem to find any in google or in this forum...
I am using Macro Builder and use gotocontrol to navigate my setfocus to another subform after pressing TAB and enter the corresponding entries.
in my main form, there are 2 subform. these 2 subforms are linked. Each record in subform1 has different datasheet entries in subform2.
My plan is in subform1, after the last field, when I press tab it will change focus to subform2 instead of going to the next record in subform1.
I was successful of running the code in changing the focus to the subform2 after pressing the tab, but the problem now is that it will display the datasheet for the next record of subform1.
Thank you in advance for the help...