Access 2016 setfocus

[willsnake]

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...

 

[theDBguy]

Hi. Just a guess but try setting the Cycle property of subform1 to Current Record.

 

[willsnake]

hi,

there is no cycle property

 

[Gasman]

That is the subform control NOT the subform?

hi,

there is no cycle property

View attachment 77344

 

[willsnake]

I am sorry if I identified it wrong...

 

[theDBguy]

I am sorry if I identified it wrong...

So, were you able to find it?

 

[willsnake]

I am sorry, my post is wrong...

It would be pressing TAB in subform control1(TblLot Subform) then setfocus will go to subform control2 (TblLotParticular Subform)?

Because I can only find the Cycle Property in the Main Form.

I am so sorry for the wrong descriptions...

 

[willsnake]

Is my intention still possible even if its not a subform, but a subform control?

 

[willsnake]

I already did the Cycle property on current record on the main form since it is only where available, but it still does not work