I am fairly new to database design and am having some difficulty
getting my combo boxes to work as I'd like them to. I would like to
create a form with two combo boxes; the first one would select
‘JobNum' from my master job table and the second would select a ‘Supt'
associated with the selected JobNum.

My tables are setup like this:
-tblEmp: Emp# (PRIMARY KEY), EmpName, etc.
-tblSupt: SuptEmp#, Job#
-tblInjury: InjuredEmp#, Job#, Supt#, etc.
-tblJob: Job# (PRIMARY KEY), JobName, etc.

How can I setup my two combo boxes so that:

Combo Box 1 selects Job# from the list of Job#'s? I can get this far,
but a can't seem to tackle the AfterUpdate event in order to
successfully populate the 2nd combo box.

And Combo Box 2 selects an associated Supt#, a list populated from the
selection in Combo Box 1?

Thanks in advance for any assistance.

Nick

Nick,

If I understand you right, you want to select a Job# and have the
second combo box update to show Supt#'s for the selected Job#. This is
what I would do.

This is done using a form. Since you have the Job# combo box working
let's look at the Supt# combo. Create the Supt# combo like normal.
Then go to the properties of the Supt# combo and go to the data tab.
Then goto row source and click the build button. From here you can add
the Job# field from your tblSupt to the design grid and set the
criteria to the Job# combo box on your form. This will tell the combo
box what to display. But to make it work like you want you have to go
to the after update property of the Job# combo box and click Code
builder. Here you will type in Me.Combo2.requery. (Combo2 is the name
of the Supt# combo box) This will requery your box every time you
change something in the Job# combo box.

If your confused let me know and I can e-mail you an example.

Good luck,
Wes

nfemal (AT) findorff (DOT) com (nick) wrote in message news:<d7b63544.0408191321.761dccd8 (AT) posting (DOT) google.com>...