Code to add new records to a table

H

Howard

I need to populate a table at the click of a button
control. Can someome provide me with a sample set of
instruction to code in the click event for the button
object? Use as an example a table called "components" with
three fields; customer_id, component_id, and price. In
actuality, there will be about a dozen fields set per
record and up to 50 records created per iteration.
The instructions need to set the record field values and
save the record (I guess ???). I will be creating dozens
of records (different field values) for each new customer.
Some of the field values will be taken from fields on the
form, but the majority will be hardcoded.
Thanks!
-Howard
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copy previous record into form field 0
How do I clear a form? 0
Code to add records to an existing table 1
Add records to table 4
Add New Record Button: How to Get Mouse Cursor in Specific Field Upon Clicking? 1
Access 2013: Form problem in reading data tables; relationship one-to-one 0
Adding Records to a table 4
'Add Record' button on a form 7

Top