best event for update code?

[STeve Lefevre]

Hey folks -

I'm working on a form. The form is in datasheet view. There are two
fields of concern: "Score" and "Answer".

I'm having problems getting the behavior I want out of it.
Score and Answer are both drop downs. Only Score has a tab stop.
Normally, the user will type in a single number for the Score, 0-9. It
should then update Answer based on the score, and move the cursor to the
Score field the next row down. All this on a single number keystroke.
The idea is that they can fly through the whole form by pressing only
number keys.

The problem is, I can't figure out which event to base this updating
code on. Keypress events screw stuff up if the user tries to tab back
into the previous row.

How should I do this?

Steve Lefevre

[Bradley]

STeve Lefevre wrote:

Hey folks -

I'm working on a form. The form is in datasheet view. There are two
fields of concern: "Score" and "Answer".

I'm having problems getting the behavior I want out of it.
Score and Answer are both drop downs. Only Score has a tab stop.
Normally, the user will type in a single number for the Score, 0-9. It
should then update Answer based on the score, and move the cursor to
the Score field the next row down. All this on a single number
keystroke. The idea is that they can fly through the whole form by
pressing only number keys.

The problem is, I can't figure out which event to base this updating
code on. Keypress events screw stuff up if the user tries to tab back
into the previous row.

How should I do this?

Steve Lefevre

Ummm..

Enter score... OnUpdate set answer and then move to required record
(probably the next record)... SetFocus to score field (not needed if
it's the only Tab stop)
--
regards,

Bradley

[STeve Lefevre]

Bradley wrote:

Ummm..

Enter score... OnUpdate set answer and then move to required record
(probably the next record)... SetFocus to score field (not needed if
it's the only Tab stop)

The problem with OnUpdate is that it wants the tab or enter key to be
pressed. Ideally I would like for the user to just hit, say, 5, it it
would jump to the next record.

[Bob Quintal]

STeve Lefevre <le********@osu.edu> wrote in
news:VI**************@fe2.columbus.rr.com:

Hey folks -

I'm working on a form. The form is in datasheet view. There
are two fields of concern: "Score" and "Answer".

I'm having problems getting the behavior I want out of it.
Score and Answer are both drop downs. Only Score has a tab
stop. Normally, the user will type in a single number for the
Score, 0-9. It should then update Answer based on the score,
and move the cursor to the Score field the next row down. All
this on a single number keystroke. The idea is that they can
fly through the whole form by pressing only number keys.

The problem is, I can't figure out which event to base this
updating code on. Keypress events screw stuff up if the user
tries to tab back into the previous row.

How should I do this?

Steve Lefevre

The keypress idea is the best method. You just need to put some
code to read the keypress and perform a different action if a non-
number key like {shift}{tab} or {esc} is pressed.