Access 2003 submenu - lookup

M

ms_user

I am new to Access and I am trying to setup a basic form but I'm running into
some trouble. One of the items I want to have on this form is a term-specific
field (for college purposes.) For example I want a year lookup menu to
display years i.e. 2006,2007, 2008, etc and then a term field to only display
the terms associated with those years. If I were to select the year 2007, the
term lookup field should only display 2007-1, 2007-2, or 2007-3. I have read
the posts, google groups, and access help and I haven't be able to find
anything that I can use. I am new to this so hopefully there is a fairly easy
way to make this happen without writing code (which I don't know how to do.)

Thanks in advance for the help.
 
Top