ComboBox to Control Specific Field Display

[redearth777]

I am try to limit the fields that are displayed in a subform based on the selection of the combo box.
The table has a StudentName, test1, test2, and test3 among other fields.
I am trying to create a form that will only display the student name and one of the test fields based on a combo box selection.
How can i do this, or is there a better way go about it?

Thanks

[NeoPa]

This is possible to do, but you will need to make your question clearer.

What determines which control, of which set of controls, should be displayed?

[redearth777]

I hope this makes it clearer. In the main form all i want to have is the combo box for selecting the field test1, 2, or 3. Then in the sub form the only fields from the table to be displayed would be the StudentName (which would always show) and then the Test 1, 2, or 3 to input their grade depending upon the selection of the combo box.

I know this can be done through setting the combo box to display the field names, but the challenge i am running into is that i do not want create a separate table for the test scores (if i don't have to) so currently when try to set the combo box to display the fields, i am displaying all the fields from the table and not just the three i want to choose from.

[NeoPa]

Assumptions (As you don't share the names you use, or much really, I'll invent some and you can translate) :

1. We have an unbound ComboBox control (called cboSelect) on your main form which returns values 1, 2 or 3.
2. We have a SubForm control named sbfTest on the main form.
3. We have three controls on the subform called txtTest1, txtTest2 & txtTest3.

You can design the three TextBoxes to be invisible. They can also be designed to take up the same space on the subform, as only one will be visible at any one time.
In the AfterUpdate procedure of the ComboBox (cboSelect) select which TextBox is visible :

Private Sub cboSelect_AfterUpdate()
  With Me.sbfTest.Form
    .txtTest1.Visible = (Me.cboSelect=1)
    .txtTest2.Visible = (Me.cboSelect=2)
    .txtTest3.Visible = (Me.cboSelect=3)
  End With
End Sub

Let us know how you get on with this.