Forms

[Very Basic User]

Hello All,

I'm building a database to track steps of a root cause analysis tool. There
are 7 steps to the process; I'd like to have a specific form for each step
that all feeds one primary table. I'm able to make each separate form, but
I'm not sure how to ensure that each form is updating the same issue. For
example. If I open step 1 and start an issues # 0001 each form that I open
for each step following needs to update # 0001. The problem is that I may not
complete all steps together and don't what to have to search for the # each
time I open a new form. I thought about making one long form and trying to
hide portions as I move through steps, but don't know how to do that either.
Any suggestions would be appreciated!

 

[Golfinray]

It would be easier to build a mainform and 6 subforms. Link them where each
number that comes up in the mainform also comes up in the subforms. It may
take some manipulating to get them all on one page. The subform wizard should
build the subforms and link them for you. Formatting is the bear. Post back
if you need help formatting.

 

[John W. Vinson]

It would be easier to build a mainform and 6 subforms. Link them where each
number that comes up in the mainform also comes up in the subforms. It may
take some manipulating to get them all on one page. The subform wizard should
build the subforms and link them for you. Formatting is the bear. Post back
if you need help formatting.

Formatting can be made a LOT easier by using a Tab Control. You could have a
Tab Control with six pages, a subform on each page sharing the same screen
real estate.

that's not *necessarily* the best solution, but it's *a* solution to this
particular issue.