LINK COMBO BOX WITH TABLE

[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

 

[Mike Painter]

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

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.