Double click to open record performs no action

[spleewars]

I've been struggling several time with this problem and apparently its driving me a little crazy: i have this code

Private Sub CodeNumber_DblClick(Cancel As Integer)
DoCmd.OpenForm "Products", , , _
        "[products.codenumber]=" & "'" & Me.CodeNumber & "'"
 
End Sub

I cannot understand why on other forms this code works flawlessly and sometimes on others no. I have used this sort of code many other times on lots of other forms and worked properly but in this one, nope! The form automatically open on double click and where it is suppose to load the record, the form 'products' open itself with no loaded record.

What in the heck is wrong?

Update:

Further testing made: removed all code and enabled and unlocked some disabled fields from form Products, changed "'" with "", "#"

Tried this code as well

"[products.codenumber]=" & "'" & Forms![search_advancedstock]![search-advancedstock-datasheet]![CodeNumber] & "'"

and still nothing...

[dsatino]

if the codenumber field is numeric, you have to remove the single quotes

[spleewars]

tried as well for trial purposes. didn't worked either. however the code number is composed of numeric and text so single quote is to be used

[Rabbit]

[products.codenumber] will only work if your field is actually named that. Which I doubt. You're either looking for [products].[codenumber] or just simply [codenumber].

[spleewars]

Thanks for your input rabbit. After spending hours trying to find the answer to the question, i finally found out that it was all fault of a statement in a query. Set a workaround on a new query and fixed the problem. Thanks all!