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