save value of unbound text box to a table

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

Guest

On my form I have an unbound text box that get its information based upon
what the user selects in a combo box list.
Me!Textbox1.Value = Me!ComboboxQuery.Column(1).
How do I save the value of the unbound text box to a table?
 
While it can be done, why? Since the combo box will have a direct
relationship between its columns, saving the value of the combo box (Bound
Column) should always indicate what the value of Column(1) was. Therefore,
retrieving the value in the combo box's Control Source field and linking the
table that supplies the combo box's Row Source will yield the value of
Column(1).

It is not considered proper database procedure to store data that you can
otherwise calculate. There are exceptions to this rule, but they should be
considered as only a last choice and are usually just for historical archive
purposes.
 
Back
Top