Problem with tab key on last control on a form page

[akotronis]

Hello everybody.

I have made a form for data entry which has some pages. A next page button is the last control on each page and a go to next page command is triggered on click event (which has been entered using vba) and it works fine. Now the bad thing is:

If the user hits tab or enter when the next page button is on focus, he/she goes to the next record which is something I don't want, as he/she may not realize it and continue entering values as if he/she was in the previous record.

I tried entering on key press event for the next page buttons

If KeyCode = 9 Then PageWhatever.SetFocus End If

but it just ignores it... Any ideas on why this may happen?

Thanks in advance

[rpeare]

set the TAB STOP property of your NEXT button to NO

Then they will never be able to activate it without physically clicking on the button.

[June7]

In addition to rpeare's suggestion, I give users option of activating buttons with click or key strokes by using the shortcut key indicator. Type an & in front of letter in button Caption and the button can be triggered by pressing Alt+letter. If it is a form without any data controls, such as a 'main menu', the Alt isn't even needed, just press the associated letter.

[akotronis]

Hello again. Thanks for the reply. However I don't know how to do that, (I am a beginner). All the code that have put into the form was on a certain event via the property sheet of the corresponding control. Does this one have to be entered in the same way? If yes, on which event? Regarding the syntax, I have found this:

Forms("My form").Controls("My control").TabStop = False

and tried to enter it as follows:

Create->Module and entered it replacing the parameters for the form and control and saved it. But obviously this is not the way it way supposed to be entered as it doesn't work..

[June7]

TabStop is a property that can be set on the Properties Sheet on the Other tab. Form in Design View, select the button, set the property.

[akotronis]

Oh, I found it. However, the problem remains. If I press tab being on the control just before the button, it goes to the next record (the thing I want to avoid), just not passing the focus on the button (it goes to the control just after it). The worst is that now, using the same steps described but with the Enter button, it also goes to the next record (something which didn't happen with the tab stop property set to yes)

[June7]

Actually, probably need to set the form Cycle property to CurrentRecord, also on the Other tab. Make sure the form is selected. Click on the little box at upper left corner.

[akotronis]

With the CurrentRecord sellection it behaves just as I want, even with Tab Stop = yes. Thank you both guys!