Add text box value to table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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

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