Save to a closed table

  • Thread starter Thread starter Chris
  • Start date Start date
C

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
 
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
 
Back
Top