Need a button to add records to subform table without link

K

kubotakid

I have three tables on a form/subform Master on main form. I want some of
the information on the master table to be added to the third table on the
subform with a button click. yes add a new record to child2 table. Child1
and Child2 tables are linked and I don't want these linked to the master at
this time I think.

How is this done?
 
J

Jeanette Cunningham

Hi kubotakid,

this is done using an update query.
After the query has added the record to the child2table, you requery that
subform to show the record in the form.


Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia
 
Top