Changing row source in combo box 'B based on contents of combo box

[Guest]

I hope this is simple enough:

I'm trying to make my form such that as I fill it in, it narrows down
the choices in the next combo box, and so on, until I get to the final
data.

So, for example, I want to have

1.) Combo box that lets me select a job name. The job name has only
certain shifts that apply to it, so I want to remove the
non-applicable ones for the next combo box.

2.) In the other combo box, I have the row source set do to exactly
this; and it sorta works... if I choose the properties on combo box2,
and then build the 'row source' section, which is basically a query
design form. If I swap the query from design to table view, it works
perfectly -- only the applicable shifts are there.

Of course, the problem is the combo box doesn't actually show the
results from the 'row source' query.

And, in case it matters, here is a description of the relationships:


Job Name Key----\

Job classification key---\

Shift Key-------/ >Job Pay Scale
Pay Grade----------------/

And so on; I'm not sure if this is even correct DB design, having been
thrown into this without much formal training; but Access seems to
like it much better than other methods I've tried.

Anyhoo, I want my form to do this:
1.) Let me select the job name. (combo box)
2.) Which narrows down to the applicable shifts, which I then select (combo
box)
3.) Which further narrows things down to pay scale (combo box select)
4.) Repeat step 3 one more time.
5.) Auto-generate a form allowing me to input/edit/change the final
selection.

Thoughts? (Other than I need a few books to read...)

 

[Douglas J. Steele]

See whether the example in http://www.mvps.org/access/forms/frm0028.htm at
"The Access Web" is enough to get you going.