Auto update a combo dependant on other field values

[JohnB]

Hi.

I would like to be able to automatically insert an ID value in one combo
once another is updated, dependant on the values present in two other fields.
Can anyone help with the code for this please? I'm using A2000 on XP.

I have cboSchool and cboMentor. The same form contains txtSubject and
cboPlacementStage.

In the After Update Event of cboSchool, I want to put some code that says

" go to qryPlacementsAll, find the MentorID for the record where SchoolID =
cboSchool and Subject = txtSubject and PlacementStage = cboPlacementStage and
put that MentorID in cboMentor"

Just to explain - there will almost always be only one record which
satisfies the above criteria but I'm using a combo for cboMentor to allow the
user to change the auto inserted ID on the rare occasion where there is more
than one record and they need to manually change the ID.

Thanks for any help, JohnB

 

[JohnB]

I have reposted about this, having found some code that almost meets my
needs. See "Repost about auto populating a field" 14th Oct 2005

Thanks, JohnB