sql update command, will not take use t text box value from form

[martinrobson]

Hi,

I am trying to get an sql update command to take the value from a textbox and put it into a table. The syntax works if i replace the textbox name with a 1, but for some reason it cant get the value from it. The syntax is similar to:

update table set column = textbox_name1 where table.column = froms!table!textbox_name2

as i say if i replace the textbox_name1 with 1 it works fine.

Any ideas?

Thanks

 

[Rolliee]

.....where table.column = froms!table!textbox_name2

Change the last terms to
".... where table.column = " & forms!

![textbox_2] & ";"

rollie@bwsys.net