Choosing from more than one subform

[anthonypete]

I'm trying to expand on a previous database for Quality Control of a
canning process, while also converting the project into Access. So far
I've come up with the idea of having a form for the production day
data, but what I'd like to do is have a macro or some other method so
that when the production code is entered, I can load an appropriate
subform corresponding to what type of production process is being
checked for quality, so that the QC employee can then enter data from
their checks throughout the data (1 production day corresponds to
several test runs at different times).

How can I set up my form so that an appropriate subform is loaded
based on the entry of their product code. I know which codes are for
which processes (several codes per process as well), I just need to
know how to choose between different subforms basically, if its even
possible.

~~~
Anthony Peterson
Burnette Foods, Inc.

 

[Klatuu]

Yes, it is possible, but I don't know that a Macro will do it. There are a
couple of ways you can do this. The easiest method would be to use a Tab
control wit ah tab for each production code. Then put the associated subform
on each tab for the production code. Then rather than the user selecting
from a combo or some other control, all they have to do is click on the tab
associated with the production code.