Solved How to go to the same field, next record in a continuous form? (1 Viewer)

[Sun_Force]

Pressing up/down Arrow keys in tables take me to the same field of the next/previous record.
How can I have the same functionality in continuous forms?

I couldn't follow the instructions in following post because of the change in UI.

Continuous (Tabular) Forms: How to Move to Next Record, Same Field with Keystroke

I'm using MS Access 2003. I've noticed that with a form in Continuous (Tabular) View, when I click the DownArrow on my keyboard, the focus does not move to the next record, same column, as it does when in Datasheet view. I want to use Continuous view because I need to put command buttons on...

www.access-programmers.co.uk

Thank you.

 

[theDBguy]

Hi. I didn't read the linked thread you posted, but in a continuous form, you would need to use VBA code to do something like that? Have you considered using Datasheet View instead?

 

[arnelgp]

add code to the Form's Keydown event.
make sure that the Form's "Key Preview" event is set to Yes.

Private Sub Form_KeyDown(KeyCode As Integer, Shift As Integer)
    'arnelgp
    On Error Resume Next
    With Me.Recordset
        If KeyCode = 40 Then     'down arrow
            If Me.CurrentRecord = .RecordCount Then
                .AddNew
            Else
                .MoveNext
            End If
            
        Else
        
            If KeyCode = 38 Then    'up arrow
                .MovePrevious
                
            End If
            
        End If
        
    End With
End Sub

 

[Sun_Force]

Hi. I didn't read the linked thread you posted, but in a continuous form, you would need to use VBA code to do something like that? Have you considered using Datasheet View instead?

Thanks for your reply. I've been asked to use a continuous form.

 

[Sun_Force]

add code to the Form's Keydown event.
make sure that the Form's "Key Preview" event is set to Yes.

Private Sub Form_KeyDown(KeyCode As Integer, Shift As Integer)
    'arnelgp
    On Error Resume Next
    With Me.Recordset
        If KeyCode = 40 Then     'down arrow
            If Me.CurrentRecord = .RecordCount Then
                .AddNew
            Else
                .MoveNext
            End If
            
        Else
        
            If KeyCode = 38 Then    'up arrow
                .MovePrevious
                
            End If
            
        End If
        
    End With
End Sub

Thanks for your time and the code. I hoped there may be a setting somewhere. While your code works but I hate using keydown event. I simply don't like run a function every time I press a key. I think that's why Key Preview property is set to No by default.

Thanks again for your help.

 

[Pat Hartman]

this Arrow key behavior is something that MS likes to change from version to version, probably just to see if we're paying attention. In my version, the up/down arrows work the way you want them to.

 

[Sun_Force]

this Arrow key behavior is something that MS likes to change from version to version, probably just to see if we're paying attention. In my version, the up/down arrows work the way you want them to. View attachment 88552

Which version are you using?

 

[CJ_London]

I couldn't follow the instructions in following post because of the change in UI.

in later versions of access go to file>options>client settings. In the editing section you will find 'move after enter'

 

[Pat Hartman]

Which version are you using?

The picture I posted tells you.

Look at File/Account and the About Access section

 

[Sun_Force]

The picture I posted tells you.

Look at File/Account and the About Access section

Sorry, I missed that. I should have looked more carefully.

 

[Sun_Force]

in later versions of access go to file>options>client settings. In the editing section you will find 'move after enter'

Will try and report back.
Thanks.

 

[Sun_Force]

in later versions of access go to file>options>client settings. In the editing section you will find 'move after enter'

@CJ_London
Brilliant. That one did the magic. Thanks for your help.