Continous Form move to next

[mission2java_78]

Continous form:

How do I go about moving to the next record using the down arrow key instead of tabbing to each field till I get to the next record?

Jon

 

[Adrianna]

use the navagation buttons on the bottom of the Screen/form window, or you can add command buttons using code, a macro, or the command button wizard to move to next record!

 

[mission2java_78]

I was trying to avoid all of those...
But I guess I should just stick with the navigation buttons access provides. Thanks,
Jon

 

[pcs]

jon,

not sure what is different for you, but in A97 the down arrow will move to the next record if a control on the continuous form has the focus
(page up/down works as well...)

hth,
al

 

[Rich]

That method only works for my version of Access on a form in datasheet view, not continuous forms unless I'm missing some hidden property I have to use this
Private Sub Form_KeyDown(KeyCode As Integer, Shift As Integer)
On Error GoTo Form_KeyDown_Err
Select Case KeyCode
Case vbKeyDown
DoCmd.GoToRecord Record:=acNext
KeyCode = 0
Case vbKeyUp
DoCmd.GoToRecord Record:=acPrevious
KeyCode = 0
Case Else

End Select

Form_KeyDown_Exit:
Exit Sub

Form_KeyDown_Err:
Select Case Err.Number
Case adhcErrInvalidRow
KeyCode = 0
Case Else
MsgBox "Error: " & Err.Description & _
" (" & Err.Number & ")"
End Select
Resume Form_KeyDown_Exit
End Sub

 

[mission2java_78]

Rich,

I even tried that and it simply goes to the next field rather then the next record...that's why I kept asking about this..it just seems odd it wont go to the next record. I have this behind my continous form's On Key Down event.
Jon

 

[pcs]

sorry to mis-lead...

in my case, i'm using contiuous subforms and the fields are locked and tab stop set to No.

pretty sure that is the difference...

al