Load Data Into Table Through Program

Hello All,

I would like to load a new row of data into a table from VBA programming.

For example, in a payroll database, the user enters a form and
on exiting, I want to add another row of data programmatically based
on what the user entered in the entry form.

Also, I would like to sometimes update one field of the row entered by
the user.

How can I load new data or update existing data from program?

Thanks

You have to have a way to trigger the sub in VBA. Depending when you want the data entered or updated either when the user loses focus on a field or before the form unloads. Look in VBA and find the event that would pertain to the situation you would require and place the update code in that event code. The description of what you want to update is general so I can't give exact coding that would be required. Find a good VBA for Access book and it will describe the what your looking for in the way of code. It will require some studing on your part to do it, but it shouldn't be that complicated. I hope this helps.