"Enter parameter value" input box when running SQL statement

[swk003]

I am trying to run this update query and keep getting the "Enter parameter value" input box when i try and add text data. The updating works fine with numeric data type but not with text type data. The database field is set to text type but still no luck. If I go to the query
design window I can build and run a query based on the same parameters and update the field without any problems (no input box popping up) regardless of data type. I am wondering how I can get around it. Any ideas? here's the procedure:

Private Sub Command67_DblClick(Cancel As Integer)

DoCmd.RunSQL "UPDATE tbl_Validation_data SET [AbbotBoxNumber]=(" & Me.txt_AbbotBoxNumber & ") WHERE RGCBoxNumber=(" & Me.txt_RGC_BoxNumber_unbound & ")"

End Sub

thanks

 

[mp9]

Try this:

DoCmd.RunSQL "UPDATE tbl_Validation_data SET [AbbotBoxNumber]='" & Me.txt_AbbotBoxNumber & "' WHERE RGCBoxNumber='" & Me.txt_RGC_BoxNumber_unbound & "'"

If they're are text fields/value you need to enclose them in quotes.

http://www22.brinkster.com/accessory/

 

[swk003]

Hi mp9

I get a data type mismatch in criteria expression when I put quotes where you have suggested. Are the quotes in the correct places?

 

[PHV]

keep getting the "Enter parameter value" input box
And what is the name of the asked parameter ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[swk003]

Hi PHV

the name of the parameter box is the same as the text within Me.txt_AbbotBoxNumber that I am attempting to update to the table, uncanny!!!

 

[PHV]

So, is this text an acceptable number for AbbotBoxNumber ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[swk003]

yes

 

[PHV]

And this ?
DoCmd.RunSQL "UPDATE tbl_Validation_data SET AbbotBoxNumber=" & Me.txt_AbbotBoxNumber & " WHERE RGCBoxNumber=" & Me.txt_RGC_BoxNumber_unbound

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244