S
SQL Brad
Thanks everyone..
If I want to enter data in order to print a single record for reporting
purposes, and then move that record to a 'master' table, how would I do that.
In order of sequence this is how it would work.
1. open form for table 1
2. enter records for table 1
3. run macro that prints 4 or 5 different reports for table 1
4. email three different people. One would be hardcoded email, the other
would be based on the value of one of the fields.
5. prompt that displays 'did record print ok' IF 'YES' then I want the
record moved to table2
6. emtpy table 1
thanks
If I want to enter data in order to print a single record for reporting
purposes, and then move that record to a 'master' table, how would I do that.
In order of sequence this is how it would work.
1. open form for table 1
2. enter records for table 1
3. run macro that prints 4 or 5 different reports for table 1
4. email three different people. One would be hardcoded email, the other
would be based on the value of one of the fields.
5. prompt that displays 'did record print ok' IF 'YES' then I want the
record moved to table2
6. emtpy table 1
thanks