tab order

  • Thread starter Thread starter hermie
  • Start date Start date
H

hermie

I have a form which displays the data as dynaset. The form has 10 columns
for data input. When I enter data into the first record the cursor skips to
the next column. I want that the cursor goes to the next record in the
column Is this posisble and how to do?

Hermie
 
Hermie

So, you'll show 10 columns but you are only allowing changes in one of them?

One approach would be to change the Tab Stop property of all the other 9
controls, so that a <Tab> send the cursor to the next ... record!
 
Jeff

Yes I have 10 columns for input only they are not updated at the same time.
I know it sound like spreadsheet, but in datasheet view I can do it but not
in Form view?

The input fields are the results of exams of the school
Example of form view:

name test1 test2 test3 test4 etc.
Herman A B
Jeff A A
etc.

So when I do the results of test 3, I want that the cursor goes from Herman
to Jeff and not to test4 etc.

Herman
 
Hermie

My purpose in referring to spreadsheets was to point out that Access is NOT
a spreadsheet, but a relational database.

If you have fields for ... Test1, Test2, Test3, ..., you might as well be
using a spreadsheet instead. This is not a well-normalized design, and you
will have to struggle mightily to get Access to handle your data with the
tools it has.

You could think of it this way ... while it would be possible to drive
nails with a chainsaw, it isn't the right tool, it is more difficult that it
needs to be, and you, the nail, and the wood are likely to get hurt!

Again, if all you want to do is go from Hermie to Jeff, consider using a
spreadsheet.
 
Back
Top