Appending Data to a Table

  • Thread starter Thread starter T Liden
  • Start date Start date
T

T Liden

I need to append data that is showing in a form to a table.

Most of the controls are bound to a query's fields, but there are a few text
boxes that the user inputs some infomation into manually that needs to be
appended as well.

The user chooses a job # and then the info for that job comes up from the
query. The user then fills in the text boxes with the appropriate info and
then I want them to click on a button to append the data to an existing
table.

Could you please give me some example of the VB code that I would use to
execute this procedure?

Thanks!!
Tim
 
You don't need any VB code to do this! Just base your form on the existing table
and make the fields you want the data to be added to the table bound controls.
When you go to a new record or when you close the form, the data in the bound
controls will be added to the existing table.


--
PC Datasheet
A Resource for Access, Excel and Word Applications
(e-mail address removed)
www.pcdatasheet.com

· Design and basic development for new applications
· Additions, Modifications and "Fixes" for existing applications
· Mentoring for do-it-yourselfers who want guidance
· Complete application design and development
· Applications Using Palm Pilot To Collect Data And
Synchronize The Data Back To Access Or Excel
 
Back
Top