Adding Records to a table

  • Thread starter Thread starter Howard
  • Start date Start date
H

Howard

I need to populate a table at the push of a button
control. Can someome provide me with a sample set of
instruction to place in the click event for the button
object? Use as an example a table called "components" with
three fields; customer_id, component_id, price
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.
Thanks!
-Howard
 
Not sure what you are asking. You want to click a button and add records to
a table? Where do you get the data?

If you build a data entry form you can simply press page down after filling
in the blanks.

Blease explain further.

Rick B


I need to populate a table at the push of a button
control. Can someome provide me with a sample set of
instruction to place in the click event for the button
object? Use as an example a table called "components" with
three fields; customer_id, component_id, price
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.
Thanks!
-Howard
 
Sorry Rick!
Good point. The information will come from unbound fields
on the form that also contains the button. These are
unbound fields on an unbound form. For argument sake the
form is called NewSystem and the fields on the form have
the same name as the table fields. Does this clear things
up? Let me know. Thanks!
-Howard
 
One more "also" ... one of the fields (ID) will be a auto
number primary index. Does that change the picture?
-Howard
 
Back
Top