LINK COMBO BOX WITH TABLE

  • Thread starter Thread starter count yes or no
  • Start date Start date
C

count yes or no

i have a combobox in FORM which shows all the table fields. I put an unbound
text box where i can input 'quantity'(number) in to each of the table fields.
how can i link the FIELD chosen from the combobox with 'quantity' in textbox
so it gets updated in the table.Please help.thank you
 
count said:
i have a combobox in FORM which shows all the table fields. I put an
unbound text box where i can input 'quantity'(number) in to each of
the table fields. how can i link the FIELD chosen from the combobox
with 'quantity' in textbox so it gets updated in the table.Please
help.thank you
Click to expand...
You would need to run an update or append query which you built in code.
What are you trying to do?
Having a number of fields which do the same thing violates the ideas behind
a relational database. It is almost always a bad idea and will *always*
require more work to maintain as time goes by.
 
Back
Top