stop subform datasheet from scrolling to next record!

[adams937]

This seems so simple, but I can't find the setting I'm looking for....

I have a subform that is displayed in datasheet view. When using the form, it's common to scroll through the columns using the arrow keys until reaching the desired column. If you scroll too fast and reach the end of a record, access will continue scrolling at the beginning of the next record.

Is there a way to set the datasheet view to stop scrolling when it reaches the end of a record? I'm hoping to make the interface feel more like excel.

Thanks!

 

[John Big Booty]

In the On Lost Focus event of the last field of your datasheet put the following code;

Me.YourFirstFieldName.SetFocus

Caveat Emptor; this code will send the cursor back to the first field in that row when ever the last field looses focus.

 

[cardgunner]

I have tried to do this but it doesn't work. My code on the lostfocus event is

Private Sub other_LostFocus()

Me.alt_id.SetFocus

End Sub

 

[John Big Booty]

In what way doe it not work

 

[cardgunner]

Well when I tab out of field other it's supposed to go to field alt_id but it goes to the next field in the tab order.

I'm trying to solve an issue I have in a subform where I don't want to go to the next record. I have posted the db and my issues here http://www.access-programmers.co.uk/forums/showthread.php?t=234165

 

[John Big Booty]

If you simply want to restrict the user to the current record, then set the Cycle property to Current Record

The following code will prevent the user from tabbing into a new record if you put it in the On Lost Focus event of the control that is the last Tab Stop for your form;

With Recordset
    If .AbsolutePosition = .RecordCount - 1 Then
         DoCmd.GoToRecord acDataForm, "YourFormName", acFirst
         Me.YourControlName.SetFocus
    End If
End With

 

[cardgunner]

If you simply want to restrict the user to the current record, then set the Cycle property to Current Record

This worked great. Thank you very much.