Access - Tabbed Form - Continuous Subform Control - 1 Input field per record -
Posted on 2012-09-11
May be a picky question but here goes.
Have this tabbed form. 8 tabs each with a subform as a control.
On one particular tab, the form loads via a command button and it sets up a specific number of records to be filled in. The form is limited to filling in only those particular number of records. The user is inputting 1 amount in a field called Amount.
So they input Amount record 1, Amount record 2, Amount record 3, Amount record 4 etc....
When the hit tab or enter it of course goes from record 1 to 2 to 3 .... but when they get to the last record of the form and hit enter it sits on that line with the amount highlighted. I think that's dangerous in that when they go to switch tabs they could hit another key and not know it because the other tabbed form opens....
I tried a very narrow unbound text box that's locked but tab enabled but, they have to hit the enter or tab key twice to go to the next line.
Is there a way, that I can code some sort of rowcount for the displayed form lines and when they get to that last line it unlocks or enables the tab stop but disables the tab stop to that unbound box if they're on line 1, 2, 3 etc whatever row BEFORE the last row on the input form???????