How to make Microsoft Access Continuous Forms mimic Excel's freeze pane?

I've been taking an Advanced Timesheet Sample online created by Helen Feddema and trying to advance it to allow for an entire months' worth of time entered.

My problem is where I need MS Access to freeze pane (similar in Excel) function the first three columns as you scroll to the right going further in the month.  So my idea was to create a main form with two subforms (A,B) that would cooperate as each row is touched and entered and would use the same temp table:  tempID to coordinate location.  

Question 1: (How to get key down access the other subform and then come back to original subform?)

I got the coding (key down) to go up within rows on a Continous (not datasheet) form - but not sure how I can get the cursor resting at that particular row in the second subform (B) go to that location AND then come back to its original position in subform A?  If I have to do it for each cell - just let me please have one example and I'll do the rest for the trouble.

Question 2:  (How to tab from one subform to another?)
Same thing needed when I tab from column 3 in subform A - has to go to column 1 same row in subform B...  I assume it will be the same coding except we will be looking for the TAB key press....

Question 3:
Finally as I scroll down horizontally and pick a new row - it will go also down to that row in subform B and then back to where you are...

Then it all has to work vice versa.  So I'll take what you can give me and make that work on my side based on the replies.

Here is provided a sample thus far.  it uses some parameters to load but all I'm concerned about is providing some navigation that mimics Excel.

Question 4: Is what I'm doing the best effective method to do this or is there something I'm not aware of?

Thank you sincerely for any help.  Much appreciated!
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Forms in DS view HAVE a freeze pane option similar to Excel.  You don't need code or multiple subforms to make this work.
Gustav BrockCIOCommented:
This has been answered here:

Freeze datasheet columns programmatically

Here is how to do it manually:

Freeze fields in an Access datasheet
stephenlecomptejrAuthor Commented:
I'm sorry I mis-stated the question.  This is not a datasheet form but instead a continuous form.  I have greater control on the continuous form to format the look and feel of what I want to accomplish.

Let me show you Example A as it looks like and Example B is what it looks like when it's a datasheet:
Price Your IT Services for Profit

Managed service contracts are great - when they're making you money. Yes, you’re getting paid monthly, but is it actually profitable? Learn to calculate your hourly overhead burden so you can master your IT services pricing strategy.

Gustav BrockCIOCommented:
But only a form in DatasheetView can freeze columns.

You could juxtapose two subforms, the left with the "frozen" fields, the right with a horisontal scrollbar.
Then (to some extend) sync the two subforms:

Synchronizing Multiple Subforms in Access

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
stephenlecomptejrAuthor Commented:
Wow that link is simple but complex all at the same time.  LOL.

What I don't understand at first is how does clicking on the tab - fire the event to sync the subforms?  I don't see a click event anywhere - normally on the tab or pages there...  So I'm still digesting this...

I'm also assuming that CBF means code behind form - correct?
"Copy and paste all code from the CBF module of form PPA to the CBF module of the new form."
Gustav BrockCIOCommented:
Yes, CBF is that.

It is controlled by the textbox txtSyncSubforms - which calls the function behind the scene.
stephenlecomptejrAuthor Commented:
Wow Gustav, great job with this one!  I figured everything out and got it working as described above..
I love the way you click on the row either subform left or right it goes to that record - however the one thing missing - is the rows don't line up when you scroll further down.

(Please note provided sample)
For example in Subform A - scroll down to Job Ticket # 14 - click on that combo box -with the value 14 - now notice Subform B - it does go to that record BUT... I would like the rows to match evenly each time.

Have any ideas you can get it to that to work?  That would just make this thing perfecto!!!!  I'd figure you like a challenge!
Gustav BrockCIOCommented:
Yes, that is a (or the) limitation as well as a challenge, and - sadly - well known.

There is no simple way to solve it. The closest you will get, is this old code from the days of Windows NT/2000:

I have never had neither the time nor the need to check it out - it may very well cease to operate on today's Windows versions.
stephenlecomptejrAuthor Commented:
Appreciate all the comments.
stephenlecomptejrAuthor Commented:
Hey Gustav, do you have happen to have an older version of MS Access to convert that template file: SetGetScrollbarsVer7.mdb one to a modern .accdb file and post here?
Gustav BrockCIOCommented:
Yes, here's the accdb. I haven't checked it out.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.