Update field on form after one field is chosen

From: DJ UDX (DJ.UDX.12boef_at_nospam.MSAccessForum.com)
Date: 02/28/04 

Date: Fri, 27 Feb 2004 18:27:44 -0600

Hi.

I am new to access completely and presumably have some difficulties.

This is from a school project which is due in two weeks, so I think I
have some time for this project.

The project is student registration for some college.

Where I have difficulty is actually a form created from the Enroll
Table.

Here are the pictures;

[image: http://home.arcor.de/udxbox/images/SR_Database.jpg]

[image: http://home.arcor.de/udxbox/images/Enroll_Form.jpg]

Here's the question part;

If you look at the form it's quite simple. Course Name has values such
as ENG, MIS, ACT and so forth. However as of know only English has
course numbers 101, 102, 103. When I click on Course Number how can I
get it to only show values that are only for "SELECTED" course above
it.

I was thinking that I have to specify something "after updating" Course
Name Field. I attempted to mess with SQL statements with no go (well I
am thinking that SQL statement can't do this because it would only pull
values from tables, not from the form itself, such as where Course Name
= ENG but that would only display ENG values; what if student selects
MIS first?)

I am still at the beginning stage and of course a lot of modifications
still need to be done.

Thanks ahead, UDX

------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/