Access 2016 setfocus (1 Viewer)

willsnake

Registered User.
Local time
Tomorrow, 04:45
Joined
Dec 3, 2018
Messages
52
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

I’m here to help
Staff member
Local time
Today, 13:45
Joined
Oct 29, 2018
Messages
21,358
Hi. Just a guess but try setting the Cycle property of subform1 to Current Record.
 

willsnake

Registered User.
Local time
Tomorrow, 04:45
Joined
Dec 3, 2018
Messages
52
hi,

there is no cycle property

supply.jpg
 

willsnake

Registered User.
Local time
Tomorrow, 04:45
Joined
Dec 3, 2018
Messages
52
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

Registered User.
Local time
Tomorrow, 04:45
Joined
Dec 3, 2018
Messages
52
Is my intention still possible even if its not a subform, but a subform control?
 

willsnake

Registered User.
Local time
Tomorrow, 04:45
Joined
Dec 3, 2018
Messages
52
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
 

Users who are viewing this thread

Top Bottom