Hi
I've a users form for say two depts. Finance and Marketing. Initially it was planned that one dept would process the data and the other could only view the input. Responsibilities have now changed so both users may have to access the same forms for data input.
My problem is that whilst i can use the docmd commanmd line to get the finance or marketing user to go down separate routes to the shared form on the way back it creates problems as i'm using simple docmd functions. I guess i could create identical forms therefore this will send the user only back to finance or marketing and not a marketing user back to finance but having duplicate forms seems daft and error prone.
if this is not clear enough please let me know.
I've a users form for say two depts. Finance and Marketing. Initially it was planned that one dept would process the data and the other could only view the input. Responsibilities have now changed so both users may have to access the same forms for data input.
My problem is that whilst i can use the docmd commanmd line to get the finance or marketing user to go down separate routes to the shared form on the way back it creates problems as i'm using simple docmd functions. I guess i could create identical forms therefore this will send the user only back to finance or marketing and not a marketing user back to finance but having duplicate forms seems daft and error prone.
if this is not clear enough please let me know.
