J
jerryb123
How do I append data from a form into a new record in an existing table?
I have a form that I want to use to generate the following fields: Sales
Rep, Agent, Subagent, Revenue, Commission and Transaction Number. I have
combo boxes so that the user can select the Sales Rep, Agent and Subagent
based on values in a reference table, and I have text boxes for the user to
manually input dollar amounts for Revenue, Commission and Transaction Number.
Once the user has made selections from the combo boxes and entered values in
the text boxes, I want them to be able to press a button so that these values
are appended into an existing table.
Any help is greatly appreciated!
I have a form that I want to use to generate the following fields: Sales
Rep, Agent, Subagent, Revenue, Commission and Transaction Number. I have
combo boxes so that the user can select the Sales Rep, Agent and Subagent
based on values in a reference table, and I have text boxes for the user to
manually input dollar amounts for Revenue, Commission and Transaction Number.
Once the user has made selections from the combo boxes and entered values in
the text boxes, I want them to be able to press a button so that these values
are appended into an existing table.
Any help is greatly appreciated!