Automatically updating fields

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Ashley Horsley (ashleyhorsley_at_tiscali.co.uk)
Date: 08/19/04 

Date: Thu, 19 Aug 2004 17:43:05 +0100

Hi,
Please can you help. I am in desperate need of answers.
I have a database that has got a field called CandidateID and several other
forms using this field as a relationship for data.
On one of the forms there is a field called Course1ID, and then fields
Course2ID up to Course4ID. Then on a different form, I want the value in a
field called Course1ID to automatically update to the one specific to a
Candidate ID, when the CandidateID is selected in a drop-down field on that
form.

Is this possible?

Please help.

Ashley Horsley
ashleyhorsley@tiscali.co.uk

Hi,
Sorry but could you explain what you mean by normalised?
The database is structured so that one form is for entering personal data
(candidateID and the CourseID's that the candidate is taking)
On a seperate form there is a drop down box for candidateID and a seperate
field for the courseID. Then another set of fields are for entering the
grades the candidate obtained. I want the courseID value to be automatically
selected when the candidate ID is selected. So it changes when crolling
through the CandidateID's.

Ashley
"Lynn Trapp" <ltrappNoSpam@ltcomputerdesigns.com> wrote in message
news:uZiHclfhEHA.636@TK2MSFTNGP12.phx.gbl...
> Ashley,
> It is not easy to know if it's possible without knowing more about your
> database structure. Having fields named like "Course1ID", "Course2ID",
etc.
> suggests that your table isn't normalized. Could you supply us with more
> information?
>
> --
> Lynn Trapp
> MS Access MVP
> www.ltcomputerdesigns.com
> Access Security: www.ltcomputerdesigns.com/Security.htm
>
>
> "Ashley Horsley" <ashleyhorsley@tiscali.co.uk> wrote in message
> news:%23lXV7pehEHA.904@TK2MSFTNGP09.phx.gbl...
> > Hi,
> > Please can you help. I am in desperate need of answers.
> > I have a database that has got a field called CandidateID and several
> other
> > forms using this field as a relationship for data.
> > On one of the forms there is a field called Course1ID, and then fields
> > Course2ID up to Course4ID. Then on a different form, I want the value in
a
> > field called Course1ID to automatically update to the one specific to a
> > Candidate ID, when the CandidateID is selected in a drop-down field on
> that
> > form.
> >
> > Is this possible?
> >
> > Please help.
> >
> > Ashley Horsley
> > ashleyhorsley@tiscali.co.uk
> >
> >
>
>

Relevant Pages

  • Re: Automatically updating fields
    ... "Ashley Horsley" wrote in message ... your post on Monday 8/16 states that you're building this database ... when the CandidateID is selected in a drop-down field on ... I want the courseID value to be ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Automatically updating fields
    ... "Ashley Horsley" wrote in message ... your post on Monday 8/16 states that you're building this database ... when the CandidateID is selected in a drop-down field on ... I want the courseID value to be ...
    (microsoft.public.access.replication)
  • Re: Automatically updating fields
    ... "Ashley Horsley" wrote in message ... your post on Monday 8/16 states that you're building this database ... when the CandidateID is selected in a drop-down field on ... I want the courseID value to be ...
    (microsoft.public.access.formscoding)
  • Re: Automatically updating fields
    ... "Ashley Horsley" wrote in message ... your post on Monday 8/16 states that you're building this database ... when the CandidateID is selected in a drop-down field on ... I want the courseID value to be ...
    (microsoft.public.access.externaldata)
  • Re: Automatically updating fields
    ... "Ashley Horsley" wrote in message ... your post on Monday 8/16 states that you're building this database ... when the CandidateID is selected in a drop-down field on ... I want the courseID value to be ...
    (microsoft.public.access.forms)