Replies

Wendell,

The idea is to write the values into the original table for each job, The details from this table are viewed via a form that shows the original hours for the depts, the hours used in each dept via a subform to another table, and the difference shown and tallied so that the foreman can see at a glance the quoted time, actual time and remaining time for any job at a glance. this info is also available to the salesmen more for history purposes.

Nobody sees the actual tables.

This db has evolved over time as the requirements have changed and my knowledge and ability has grown. The fact that it is almost constantly in use also makes life interesting.

Regards Allan.

Wendell,

If I write the totals into the header of the subform, can I then transfer these values to the Original table directly or into fields on the main form when exiting the subform?

Allan

It’s the actual “set the form to new record” bit that has be stumped. While the rest of it may sound a bit screwy, it actually does just what I want.

So, how do I do the “set form to new record” bit using code?

I give background to my questions to try and let people know what I am trying to achieve.

Regards, Allan

Question??

If I read what you are saying correctly, how can a submission go out to a person again before it comes back?

if A has it from 5/6/01 to 20/6/01, how can A also have it from 13/6/01 to 23/6/01 as well?