Update field on form after one field is chosen

[DJ UDX]

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
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 Enrol
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 suc
as ENG, MIS, ACT and so forth. However as of know only English ha
course numbers 101, 102, 103. When I click on Course Number how can
get it to only show values that are only for "SELECTED" course abov
it.

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

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

Thanks ahead, UD

 

[Duane Hookom]

I think you have your tables wrong. The Enroll table should not have the
same values/fields as Courses. Access is a relational database so use it as
one. Your Enroll table doesn't have the students' FirstName, LastName etc so
why would it have ClassName, CourseNumber, and CourseDescription.

If you are just starting out with this, check these links:
http://www.mvps.org/access/tencommandments.htm
http://www.granite.ab.ca/access/tablefieldnaming.htm