Re: Update field on form after one field is chosen

From: Duane Hookom (duanehookom_at_NO_SPAMhotmail.com)
Date: 02/28/04 

Date: Sat, 28 Feb 2004 00:51:21 -0600

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 

-- 
Duane Hookom
MS Access MVP
"DJ UDX" <DJ.UDX.12boef@nospam.MSAccessForum.com> wrote in message
news:DJ.UDX.12boef@nospam.MSAccessForum.com...
>
> 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/
>

Relevant Pages

  • Re: Combining Recordsets
    ... enroll in 0 to many classes. ... student table and one for the Primary key of the class table. ... The three link tables all contain a PKey and CKey field. ... created three recordsets, ...
    (microsoft.public.access.formscoding)
  • Re: UML: extends .vs.generalize
    ... >>college student application. ... > generalization, but you and your friend seem to be talking about 2 ... > Family Member as a generalisation of student is helpful, ... It's supposed to be "Enroll Family Member". ...
    (comp.object)
  • RE: Add record programmatically with values from two recordsources
    ... Wouldn't the student have to be enrolled in the class to show up as, ... "PJ Von" wrote: ... The second combo box allows the user to select the student to enroll. ... but have no idea how to accomplish ...
    (microsoft.public.access.formscoding)
  • Re: Why are Junction Tables necessary?
    ... how do you show which student is enrolled in which class? ... You can't really add that as a field in the tblStudent unless you are only ... allowing your students to enroll in a single class, ... Microsoft IT Academy Program Mentor ...
    (microsoft.public.access.gettingstarted)