Add text box value to table

[mark]

Hi there,
Can yiu help?
Do you know what code I should put behind a button in order to add a textbox
value to a field in a table.
Many Thanks.
M

 

[Jeff Boyce]

Mark

If your form's control is bound to the underlying table's field, you only
have to save the record. This happens when you leave the record displayed
(by creating a <Save> button, or by going to a new record, or by closing the
form).

 

[mark]

My form is bound to another table and I cannot change it.

 

[Jeff Boyce]

Mark

So you're saying that you have a control in a form that is bound to one
table, and you want to (redundantly) store the value in the control to a
second table. Unless you are dealing with a one-to-one relationship,
storing data redundantly kind of defeats the purpose of a relational
database.

Consider using a dynamically-built SQL statement, created "behind" a button
click (?Save?). Execute/Run that SQL statement in the code. Make the SQL
an "INSERT INTO ..." statement.