want entry in one field to cause pop up list in other field

[snubee]

I have a form for course registration. I have a box with a drop down list of course titles. When a course is selected I would like it to list the available dates in another field's drop down box and once the date is selected it should automatically display (in another field) the course session #.

I have the courses titles, dates, and session# (based on the dates) all in one table. Should I instead have a table for each individual class? Is there an event procedure that would enable me to leave the info. in one table?

Currently the table, called Dates/Times looks somewhat like this:

Course Title Date Session#(Autonumber)
Excel 7/9/00 1
Excel 8/8/00 2
FP2000 8/8/00 3

Thanks for your help!

Susan

 

[arickards]

Create a query as the control for the form. Then see my response to Dale Cleeve, Combo Boxes and Fields. I believe your needs are analogous.