Updating a table from a textbox

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

Guest

I have two table call them table A and table b. I have a form that has a
multi-column combo box and two text boxes. When the user selects the combo
box entry it updates the text boxes with the bound columns record. I want the
form to output table b but it only outputs the combo field data not the text
data. I search the discussions and tried everything applicable anmd nothing
is working. Any help is appreciated.
 
Joe,

It is not clear what you mean by "I want the form to output table b". A
form does not "output" data. The form is bound to a table or query, and
the data controls on the form are either bound to fields in the form's
underlying table/query, or they are unbound. In the case of your two
textboxes, we would need to know whether these are bound or unbound
controls. But in either case, I doubt very much that you in fact want
the data from these controls to end up in table b. If I understand you
correctly, the combobox is bound to a table b field, right? And the Row
Source of the combobox is based on table A, right? So the textboxes
show the table A data which is related to the field bound to the
combobox, right? Well, it is not really valid design to replicate this
data into table b, as you can always easily determine this data based on
a query between table A and table b. Hope that helps to clarify
somewhat. This article discusses a topic which is related to your
question...
http://accesstips.datamanagementsolutions.biz/lookup.htm
 
Back
Top