Record selection on continuous forms

[Guest]

How do I would like to select a specific record on a continuous form from
code?
I'm running MS Access 97.

 

[Albert D.Kallal]

often, you can use a listbox in place of continues form. There is some
screen shots and ideas here:

http://www.members.shaw.ca/AlbertKallal/Articles/Grid.htm

Another way is to add a "check" box field. (however, in multi-user, this
don't work very well).

I have a working sample that uses a check box bound to a function in a
continues form. You can find it here:
http://www.members.shaw.ca/AlbertKallal/msaccess/msaccess.html

 

[Guest]

Thanks for your information. Is it possible to navigate to a specific record

 

[Albert D.Kallal]

Thanks for your information. Is it possible to navigate to a specific
record
on a continuous form? If so, how?

Not sure what you mean by navigate? I simply use the arrow keys. The problem
is that in a datasheet, the up/down arrow keys work, but not in continues
form.

However, you can make the up/down arrow keys work just like a continues
form/spreadsheet. You have to first set the forms key-preview to yes, and
then insert the following code into the key down event.

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

 

[Guest]

I would like to programmatically navigate to a specific record on the
continuous subform. Any ideas?