Save to a closed table

[Chris]

I have a form that is unbound. Within this there is a text box that allows
user entry. After the user enters a value they click a button. On this click
I would like the value of the text box to be stored into a table (users) in
the password field of a record who's lookup value is stored in a public
String.

I am getting very confused and would appriciate any help with the basics of
the above.

Thank you

Chris

 

[Steve Conklin \(Dev@UltraDNT\)]

basically, you need to run the command to do the insert in the buttons click
event, something like:

currentdb.execute "update users set password =' " & me.textbox & " ' where
users.lookupfield =' " & gStrPublic & " ' "

hth
Steve