G
guitarfunk24
I need to make a form with subforms in it have a submit button that is
connected to a temp table then transfers its data to the real table
when someone clicks submit then clears the temp table to make it blank
for the next submit. Then if someone clicks the cancel button it just
clears the temp table so no harm no fowl. The problem with this is I
have no clue how I would do this at all. I know what I want just not
how to start. So if someone could break it down for me into a step by
step process I would be so happy.
Keep in mind that the form that would have this done to it would have
one table for the main form for the name of the project and
description of the project then the subform contains another table
that has the parts numbers and prices.
connected to a temp table then transfers its data to the real table
when someone clicks submit then clears the temp table to make it blank
for the next submit. Then if someone clicks the cancel button it just
clears the temp table so no harm no fowl. The problem with this is I
have no clue how I would do this at all. I know what I want just not
how to start. So if someone could break it down for me into a step by
step process I would be so happy.
Keep in mind that the form that would have this done to it would have
one table for the main form for the name of the project and
description of the project then the subform contains another table
that has the parts numbers and prices.