how to open form with record selected from datasheet?

[ssvec]

I have a form with some records displayed in datasheet view. When you double-click on one of the records another form pops up. How can I get the pop-up form to only display the record that was double-cliked?

 

[krispi]

Set the Cycle property of your second form to 'Current Record'

hth
Chris

 

[isorders]

Set the DoubleClick on the Form with the Record to:

Private Sub Form_DblClick(Cancel As Integer)

Dim stDocName As String
Dim stLinkCriteria As String
stDocName = "frmThatOpensWhenRecordDoubleClicked"
stLinkCriteria = "[UniqueID]=" & Me![UniqueID]
DoCmd.OpenForm stDocName, , , stLinkCriteria

End Sub

It will open the form to the same record that you double clicked on.

 

[ssvec]

Thanks for your reply. Setting the cycle property did not work, it still opens up with all of the records from the table.