Open form to correct record from datasheet 1

[MichelleB]

I want to have a user "double-click" on a field or two in a record in a form that is in datasheet view (actually it is a subform) and have an entirely different form open to that record. Any thoughts? I have tried using CurrentRecord in a few different ways, but it is not working????

 

[cmmrfrds]

Code behind the Double Click event.

Dim DocName As String, YourVariable as String, Quote as String
QUOTE = Chr$(34) '- double quote for text fields, numeric omit

YourVariable = Me.YourVariable
DocName = "YourForm"

WhereClause = " yourKey = " & QUOTE & YourVariable & QUOTE
DoCmd.OpenForm DocName, , , WhereClause

Make sure the form you are opening has allow filter on. This will open your form with the one record that you double clicked on. If you want all the records then just open without the filter (where clause).

Jerry

 

[cmmrfrds]

The WhereClause above should have been Dimmed as a string.
Dim WhereClause as String

Sorry if it caused a problem.

 

[MichelleB]

Thanks! I eventually got this to work!!