Go Back   Access World Forums > Microsoft Access Discussion > Macros

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 11-06-2019, 08:55 PM   #1
willsnake
Newly Registered User
 
Join Date: Dec 2018
Posts: 47
Thanks: 3
Thanked 0 Times in 0 Posts
willsnake is on a distinguished road
Access 2016 setfocus

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

willsnake is offline   Reply With Quote
Old 11-06-2019, 09:06 PM   #2
theDBguy
Iím here to help
 
theDBguy's Avatar
 
Join Date: Oct 2018
Location: SunnySandyEggo
Posts: 5,815
Thanks: 57
Thanked 1,274 Times in 1,255 Posts
theDBguy has a spectacular aura about theDBguy has a spectacular aura about
Re: Access 2016 setfocus

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

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
theDBguy is offline   Reply With Quote
Old 11-06-2019, 09:32 PM   #3
willsnake
Newly Registered User
 
Join Date: Dec 2018
Posts: 47
Thanks: 3
Thanked 0 Times in 0 Posts
willsnake is on a distinguished road
Re: Access 2016 setfocus

hi,

there is no cycle property

supply.jpg

willsnake is offline   Reply With Quote
Old 11-07-2019, 01:17 AM   #4
Gasman
Enthusiastic Amateur
 
Gasman's Avatar
 
Join Date: Sep 2011
Location: Swansea, South Wales,UK
Posts: 4,356
Thanks: 434
Thanked 798 Times in 773 Posts
Gasman is a jewel in the rough Gasman is a jewel in the rough Gasman is a jewel in the rough
Re: Access 2016 setfocus

That is the subform control NOT the subform?

Quote:
Originally Posted by willsnake View Post
hi,

there is no cycle property

Attachment 77344
__________________
Access novice. Sometimes trying to give something back.
Access 2007

Please, please use code tag # when posting code snippets

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
Gasman is offline   Reply With Quote
Old 11-07-2019, 04:13 PM   #5
willsnake
Newly Registered User
 
Join Date: Dec 2018
Posts: 47
Thanks: 3
Thanked 0 Times in 0 Posts
willsnake is on a distinguished road
Re: Access 2016 setfocus

I am sorry if I identified it wrong...
willsnake is offline   Reply With Quote
Old 11-07-2019, 04:49 PM   #6
theDBguy
Iím here to help
 
theDBguy's Avatar
 
Join Date: Oct 2018
Location: SunnySandyEggo
Posts: 5,815
Thanks: 57
Thanked 1,274 Times in 1,255 Posts
theDBguy has a spectacular aura about theDBguy has a spectacular aura about
Re: Access 2016 setfocus

Quote:
Originally Posted by willsnake View Post
I am sorry if I identified it wrong...
So, were you able to find it?
__________________
Just my 2 cents...

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
theDBguy is offline   Reply With Quote
Old 11-10-2019, 10:27 PM   #7
willsnake
Newly Registered User
 
Join Date: Dec 2018
Posts: 47
Thanks: 3
Thanked 0 Times in 0 Posts
willsnake is on a distinguished road
Re: Access 2016 setfocus

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 offline   Reply With Quote
Old 11-12-2019, 01:27 AM   #8
willsnake
Newly Registered User
 
Join Date: Dec 2018
Posts: 47
Thanks: 3
Thanked 0 Times in 0 Posts
willsnake is on a distinguished road
Re: Access 2016 setfocus

Is my intention still possible even if its not a subform, but a subform control?
willsnake is offline   Reply With Quote
Old 11-12-2019, 01:28 AM   #9
willsnake
Newly Registered User
 
Join Date: Dec 2018
Posts: 47
Thanks: 3
Thanked 0 Times in 0 Posts
willsnake is on a distinguished road
Re: Access 2016 setfocus

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

willsnake is offline   Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
VBA code on Access Form, recording lngID as 0 in Access 2016 robarthur Modules & VBA 4 08-28-2019 07:01 AM
Access 2003 V 2016 What can 2016 do? Mike375 General 8 01-03-2019 06:29 AM
Exclude Subform Records From Combobox Already Selected Access Datasheet, Access 2016 devtr Forms 2 07-14-2017 02:06 PM
Deploying Access 2016 Front End, Access 2016 RossWaddell General 2 07-24-2016 05:43 AM
Access 2016 runtime and older full versions of Access Ktrez1 General 0 01-03-2016 05:28 PM




All times are GMT -8. The time now is 01:20 AM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World