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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

auto populate text box based on combo box value 1
filter on combo box possible? 1
Unbound text box calculation 6
Pass value to combo box 6
Save values displayed in unbound text fields from combo box to tab 3
Continuous Form - Populate unbounded field 1
Unable to select a value from combo box 3
Unbound text boxes in a Sub Form 9

Back
Top