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
 

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

Clicking link tasks again increases duration 0
Crating User Form to Add Names 1
Dynamic Naming of Form Button 3
Subform with no records 8
Setting column width in a table with a macro is not working 0
Adding data to MS Access from csv file 0
subform within subform On Main for Child master link question 2
Visio: copy text of a master shape to User-define Cells (Variable) 0

Top