Hi folks
Doing a access project for the purpose of merging 5 excel spreadsheets and word templates into one program. One reason I am doing this is to reduce repetition as a lot of the details in these documents are going to be same.
In this thread the issues is as follows:
I have 4 forms which I will name for this exercise, A, B, C, D, & E, but forget form E for the moment though (lets leave it a Myster E) :P
Each form represents a different process
Form A is the principal process but B, C, & D are optional preliminary processes that need sometimes happen before A, but not always so it is possible data in B for instance won't end up in A.
Though A, B, C & D hold different information to each other there are a series of say 5 or 6 fields which are the same in each form which I shall call Group 1, and likewise a series of fields from subforms I shall call Group 2.
So the question is how do I go about making transferring or copying certain data, when needed from either forms B, C & D all the way to form A? This would need to be done in a user friendly way as many of my collegues are tech phobic.
Now my own thoughts are that I would need to either create a button per row of data in forms B, C & D that transfers the fields to form A, or in form A I would need a button that populates certain fields and gives the option to pick from forms B, C, or D.
Unfortunately I am not sure where to start with this one. What is the best way to deal with this issue?
If its all doable I even have a bonus question around Form E? :O