I am creating a new module for our company database to track project cost vs budget. Our system is set up with multiple cost lines, each containing various cost codes. However, not all lines will be used on a project. Typically only 5-6 lines, but I need to set the form up to use the other lines if applicable.
In order to keep the form uncluttered and to a minimum, I would like to use a form (Cost Analysis Select in the attached DB) that would allow the user to select the applicable lines prior to starting a new Cost Analysis form.
My question is what would be the most efficient way to take the selected lines from the Select form and position them in the main form similar to the current layout, then hide the non-relevant lines and related codes beneath each line. What started out as a great idea seems to by rapidly becoming a long embedded if....then statement.
I'm hoping there is a better way to do this. I'm open to any and all ideas.
Note that in the attached DB, the forms are still in development. I haven't created the underlying tables or queries yet. The majority of the control boxes will ultimately be attached to a record source.
In order to keep the form uncluttered and to a minimum, I would like to use a form (Cost Analysis Select in the attached DB) that would allow the user to select the applicable lines prior to starting a new Cost Analysis form.
My question is what would be the most efficient way to take the selected lines from the Select form and position them in the main form similar to the current layout, then hide the non-relevant lines and related codes beneath each line. What started out as a great idea seems to by rapidly becoming a long embedded if....then statement.
I'm hoping there is a better way to do this. I'm open to any and all ideas.
Note that in the attached DB, the forms are still in development. I haven't created the underlying tables or queries yet. The majority of the control boxes will ultimately be attached to a record source.