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.

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

Thanks. Was going mad there.

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