Stop at last control without going into next record

[BPBP]

Hello,

lets say i have 10 textbox in a data entry form, the user enters data into the 10 textboxes. when the user reaches the last text box, and after entry and hit enter, it automatically goes into next record, how do i prevent the form from going into the next record and stop at the last textbox ?

The form will only go into next record only when a certain button is clicked with acNewRec in the on_click event.

 

[John Big Booty]

You can do this by setting the Forms Cycle property to Current Record. You will find this in the Other Tab, when the form is in design view. This will not stop the tab action at the last control, but will simply keep it cycling through the tab stops on the current record.

 

[HiTechCoach]

Hello,

lets say i have 10 textbox in a data entry form, the user enters data into the 10 textboxes. when the user reaches the last text box, and after entry and hit enter, it automatically goes into next record, how do i prevent the form from going into the next record and stop at the last textbox ?

The form will only go into next record only when a certain button is clicked with acNewRec in the on_click event.

Try setting the Form's Cycle property from 'All Records" to "Current Record".

TIP;
If you set your "Add New" command button's Default property to Yes, then the Enter key will click the command button.

EDIT: Looks like I type to slow ...

 

[BPBP]

Thanks all!

 

[HiTechCoach]

You're welcome!

Glad we could assist.