I have an issue with this access program I am working on - I have all the tables, reports, queries and modules setup but I have 2 forms - 1 form for all the end users to use so mgmt can track the work done for the day as the end user inputs the data and it gets stored in the tables;
however I have a 2nd form for the users incase the file has to go to a "2nd look" format where the users fill out this form for the reasons mgmt needs to look at the file; however its duplicating data like customer information and so on. I want to be able to have them fill out the first form then if determined by the company guidelines that a 2nd look is needed it auto fill in the generic information yet still allow them to add to the other fields but I dont know how to do this at all.
Anyone have any ideas??
however I have a 2nd form for the users incase the file has to go to a "2nd look" format where the users fill out this form for the reasons mgmt needs to look at the file; however its duplicating data like customer information and so on. I want to be able to have them fill out the first form then if determined by the company guidelines that a 2nd look is needed it auto fill in the generic information yet still allow them to add to the other fields but I dont know how to do this at all.
Anyone have any ideas??