Using combo-box on main form to open another form

[ML]

I can't find any threads that has a similar issue. I am new to MS Access
2003. I have a Main form (Data Entry) which was created using a table. I
have also create multiple forms not based on tables or queries.

Information in these multiple forms are only text, not data entry required.

I want to open the individual forms when I select based on the combo-box
created in the Main form (Data Entry).

Hope someone can help me on this.

 

[Mike Painter]

I can't find any threads that has a similar issue. I am new to MS
Access 2003. I have a Main form (Data Entry) which was created using
a table. I have also create multiple forms not based on tables or
queries.

Information in these multiple forms are only text, not data entry
required.

I want to open the individual forms when I select based on the
combo-box created in the Main form (Data Entry).

Hope someone can help me on this.

There are several ways to do this.
Are these forms essentially the same containing one or two text boxes or are
they widely different?
Are they small enough to allow the text to be displayed on the main form?

 

[ML]

Thanks Mike.

The multiple forms are designed using tabs so that i can keep all the
required text in the various tabs. It varies from form to form. The look
and feel of the forms are the same.

I would think it should fit the main form because I have created it based on
the same size. The main form has only 10 data entry fields.

The main form name is KPIs and the combo-box has the fieldname "ProjectTeam"
where the Row Source are: ProjTeam1, ProjTeam2, ProjTeam3. The forms are
also created using the same name. There will be another 15 teams added to
the combo-box.

What I want to see when the event procedure: After_Update on the combo
"ProjectTeam", the form that points to the same in the Row Source would be
appear. At the same time, I can continue to do data entry on the Main form:
KPIs

I tried the subform method but it didn't quite have the same effect because
I would need to create a lot of subforms which is not what I want.

Hope you can give me advice on how this can be done. Thanks.
ML