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


E

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.
 
Ad

Advertisements

Ad

Advertisements

E

ehadden

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

Jeanette Cunningham said:
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top