copy previous days schedule form

[cluce]

I have a form to post the days schedule for 8 to 10 construction crews. Each crew is a subform with combo boxes to select employees, equipment and locations. All fields are bound to the Schedule table. I want to open the form with a new record for tomorrow that has todays record visible because most of the men and equipment remain the same.
For now I go to the table copy and "paste append" the last recordset into a new record but I don't want the other users to have access to the tables when the database is distributed.

Thank You
Clint

 

[dinster]

go to this thread u might get an idea on how to go bout this....

thread705-1262966