Navigation in Continuous Forms

[Ballybeg]

I have set up a data entry form with multiple columns and have set up the
user with the keyboard moving down the records to facilitate speedy entry.
After the last entry in the each column I want the cursor to move to the top
of the next column to allow continuous entry, without the need to use the
mouse to position the cursor.

I was thinking of using a recordset clone and adjusting the navigation that
way. Any clues?

 

[Klatuu]

Since it is a continuous form, I am not positive this will work, but you
might try putting code in the Form After Update event to set the focus.
Also, it may be necessary to code it to move to the next record:

With Me
.Recordset.MoveNext
.FirstControl.SetFocus
End With

As I said, this is only an idea to try. Let me know if it works

 

[Ballybeg]

Similiar to what i have been trying:

after update...

if me.currentrecord = rsRace.RecordCount then' ie last record
docmd.GotoRecord,,acFirst
me.firstcontrol.setfocus
me refresh
endif


This works if the Keyboard option is set to move across a record, but it
stick at the last record when using the vertical option.

Thanks anyway

Ballybeg

 

[Albert D. Kallal]

If you're simply looking to make your continuous form operate like a
datasheet form, or cursor movement correct a spreadsheet, and the following
code will do the trick


Private Sub Form_KeyDown(KeyCode As Integer, Shift As Integer)

' key hand

Select Case KeyCode

Case vbKeyUp
KeyCode = 0
On Error Resume Next
DoCmd.GoToRecord acActiveDataObject, , acPrevious

Case vbKeyDown
KeyCode = 0
On Error Resume Next
DoCmd.GoToRecord acActiveDataObject, , acNext


End Select

End Sub

for the above code you have to set the form's key preview = yes.

The above will allow you to use the up and down arrows in a regular fashion
in a continuous form.

that you seem to hint that if the person's on the last field and it
continues form and it's down arrow weary suggesting you want to go to the
first column?

(I actually not hundred percent quite clear on what you're looking for here,
so the above might not be what you need).