Why Won't This DCount Query Work?

[DAPOOLE]

I am trying to get a count from a table with the WHERE clause restricted by whatever parameter the user enters into the textbox called 'UserDefined' however it keeps compiling errors. The code is:

Me.MyTextbox = DCount("*", "[DBO_FINAL_PUMP]", "[PUMP]= " & Me.UserDefined & " ")


Thanks.

 

[RuralGuy]

How about:
Me.MyTextbox = DCount("*", "[DBO_FINAL_PUMP]", "[PUMP]= '" & Me.UserDefined & "'")

 

[DAPOOLE]

Thanks. Was going mad there.

 

[RuralGuy]

You're welcome. Been there...Done that!