double click to open

[spleewars]

i dont know what am i doing wrong but suddenly double click on a field and open another form with a record does not work anymore:

Private Sub ordrep_DblClick(Cancel As Integer)
DoCmd.OpenForm "Orders", , , _
"[orders.ordrep]=" & "'" & Forms![customerorders].ordrep & "'"

DoCmd.Close acForm, "customerorders", acSaveNo
End Sub

... on double click is giving me error "runtime error 2501. the open form action was canceled"

why?

[pbaldy]

Try

DoCmd.OpenForm "Orders", , , "[ordrep]= '" & Forms![customerorders].ordrep & "'"

[spleewars]

i actually tried that as well but the error remains... what's dashing is that in the database i have used this code tens of times and works but with this something is wrong :S

[pbaldy]

The error is generic, but my guess is that something is spelled wrong or the data type isn't text. Can you post the db here?

[spleewars]

found the problem... its actually very bizarre however

(error) ordrep & "'"
(fix) ordrep & ""

[pbaldy]

That field must be numeric. See here for the syntax for different data types:

BaldyWeb wherecondition

[spleewars]

I never knew about the # syntax. Thanks for the quick link

[pbaldy]

Happy to help!