Fields - automatically updating

  • Thread starter Thread starter Ashley Horsley
  • Start date Start date
A

Ashley Horsley

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
(e-mail address removed)

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
 
Ashley;

Here's a start:

You will need to modify it. I used it in an OnClick Event to update a
control on a SubForm but it can be used in Your solution

Private Sub CmdButton_OnClick()
Me!sfrmName.Form!txtControlName = Me![txtWhatIsInControlOnMainForm]
End Sub

Andy
 
Back
Top