Form---Click Field to Determine Contents for Subsequent Field

[ehadden]

I am new to Access, so technical jargon is tough for me, but I am trying to
generate a form for data tracking. When I click on one field in the form
(combo box), I want a subsequent field to be limited to items that are
related to the first. Example: In the form, when I click on the particular
grade level in the combo box, I want only the teams from that grade level to
show in the next field box. After I click on the appropriate team, I want
the only the students from that team to show. I already have the necessary
tables set up with Grades, Teams, and Students. All of this data is being
pulled from separate tables, but is being combined to populate records in
another table.

 

[Jeanette Cunningham]

Hi ehadden,
here are some links to samples to download and tutorials.
http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=389 and
click the download Access 2000 (95 KB): CascadingComboBoxes2k.zip


http://msdn.microsoft.com/en-au/library/bb404901.aspx


This one has a series of links about combo boxes
http://www.accessmvp.com/JConrad/accessjunkie/comboboxes.html


Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia

 

[ehadden]

Thank you. I will see if these work for me.

Hi ehadden,
here are some links to samples to download and tutorials.
http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=389 and
click the download Access 2000 (95 KB): CascadingComboBoxes2k.zip


http://msdn.microsoft.com/en-au/library/bb404901.aspx


This one has a series of links about combo boxes
http://www.accessmvp.com/JConrad/accessjunkie/comboboxes.html


Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia