Double Click to Open Form Not Working

[mkallover]

OK, I have a subform with a field called "ARTNum" when a user double clicks that field I want a form called "frmAddART" to open with that record to display. My code is:

Private Sub ARTNum_DblClick(Cancel As Integer)

DoCmd.OpenForm "frmAddART", acNormal, , "[ARTNum] = " & Me.ARTNum

End Sub

That is opening the form but it's not displaying the desired record. I've checked everything I can think of but I can't find the hitch. I used this same technique several times on other forms and can't figure it out.

* There are no On Open events for frmAddART that could be screwy.
* The Allow Edits property of frmAddART is set to Yes.
* ARTNum is a Number data type.

Any suggestions?

 

[mkallover]

OK, I went through an old form of mine that did the same thing and I noticed that the "Data Entry" property of the functioning form was set to No. I looked at the malfunctioning form and it was set to Yes. When I changed that to No it began to work fine.

I've never used that property so I didn't realize what it did. Handy...