Question access 2010 macro & open form

[Grek]

Hello,

I'm trying to open a new form via double-click on a cell of a sub-form.

I want the form that is opened via the double click to display the record of the line that I double-clicked.

It works fine with this code:

 
Private Sub ID_DblClick(Cancel As Integer)
DoCmd.OpenForm "F_New_Non_Hedged_Share_Class", , , "[ID] = " & Me!ID
End Sub

However, since i'm trying not too much vba code, i'd like to setup that kind of thing via access 2010 macro.

So I have:
Open Form
Form Name: F_New_Non_Hedged_Share_Class


View: Form
Filtername:
Where condition:
Data Mode:
Windows Mode: Normal

Question: I'm assuming that I need to update the "where condition", but what should I put? I tried different things, ie. [ID]=[ID], etc - but without success

fyi: the dbl click is not on the ID field of the sub-form but an other field. I'm assuming this doesn't change anything?

Thanks,

[RuralGuy]

Have you tried ("[ID] = " & Me!ID) just as you had in the code?

[Grek]

Hi
Just tried. Got a msg box saying "Enter Paramater Value 'Me!ID'"

[RuralGuy]

I'm not knowledgeable with macros but how about:
"[ID] = " & Me.ID
...using a dot (.) instead of a bang (!)