Cascading combo boxes don't show control source value until requery

[bigalpha]

I have a set of cascading combo boxes. When a value is selected in Cat 1 ID, it narrows down the selections in Cat 2 ID which narrows down the selections in Cat 3 ID.

However, the values don't show up for columns Cat 2 ID or Cat 3 ID until I enter the row. Then I have it set to requery the fields because the underlying data isn't populated. But then when I leave the row, the values go away.

Why doesn't it show the underlying value from the table? Each column is bound to a field in a table - I would assume that the recorded value would show up. Did I miss something easy?

I've attached a picture of exactly what I mean.

 

[spikepl]

You cannot use cascading combos in a datasheet like this. A combo can only have one record source for all the records. One of the effects of this you are seeing.

In a continouous form, a fiddle can be applied: Pat Hartman has a fix on the web, google her name and cascading combos. Otherwise, use some other method.

 

[bigalpha]

Hmm, okay. I guess I didn't thoroughly think through my process. This will be used for a one-time data verification.

If I still use this datasheet to go through and add values through the combo boxes, it should still update the correct record with the data right? It just won't show anything until I move into the row.