code under a button

G

GWoodhouse

I have 2 tables Request and Status
In a form I have various fields from Request and an Add and Save button.

When the save Button is pressed I want to
1 - Save the new Request record
2 - Create a new Status record
3 - Assign parts of the form used to create the request record to the status
record
4 - Save the Status record.

Does anyone know how to do this as it's driving me mad....

Many Thanks.
 
R

rowiga

Maybe you could define how your tables are setup a little
better and some information about the form(s) you're using
to accomplish these tasks.
 
Top