change subform based on form selection

[peterschott]

Greetings! This forum has been most helpful to a rusty Access user.

I'm creating a student group score entry form, having problems with creating the form I want. Say for example we have the following:
1. Three groups: A,B, and C.
2. Group A has 5 students, Group B has 3, and Group C has 20.

I want a form where I can select group A, and a list of the students will populate and enable me to enter scores for all of them on the same page. This will save time not having to re-enter the information for so many students. If anyone has a clue of what I'm talking about or is willing to lend me aid, I would appreciate it.

Cheers.

 

[peterschott]

thank you and clarification

Thanks, I will give that a try. I should clarify, there are three tables:
1. Group listing (says that Group A is about Fly Fishing, taught by Jon Reel, B is about TV commercials taught by Mr. Nielsen, etc.)
2. Group Membership - Student Betty Brown is a member of Group A and B
3. Group Scores - Stores the scores for the group and the date of the group.

I set it up this way for several reasons:

1. If groups need to be added or changed, makes it easier.
2. Easier to add or change group membership.

In the meantime I will be trying the recommendation you had. I was going along those lines but not quite foolish enough to brave through it all. (Yes, I am rusty with access).

If the above information changes your recommendation please let me know. If not, then - woo hoo!! - I'll have it and let you know the results.

 

[SheaLee]

Very nice!!