Combo box dependency

[abcrf]

Hi everyone,

I'm trying to limit the values in a combo box (Combo33) based on the previously-selected value of a different combo box (Combo42) in the same form (FRM_TRAINING_PROTOCOL). In the row source for Combo33, I have:

SELECT TBL_PROTOCOL.[PROTOCOL NUMBER] FROM TBL_PROTOCOL WHERE (((TBL_PROTOCOL.[STUDY NAME])=[Forms]![FRM_TRAINING_PROTOCOL]![Combo42])) ORDER BY TBL_PROTOCOL.[PROTOCOL NUMBER];

(TBL_PROTOCOL is a list of protocols by study that users need to be trained in, and the training record is contained in TBL_TRAINING_PROTOCOL.)

Back in form view, though, Combo33 is not updating based on the value of Combo42. What do I have wrong in the above code?

Thanks for your help!

 

[pbaldy]

For that method you'd need to requery the second combo in the after update event of the first.

http://www.baldyweb.com/CascadingCombo.htm

 

[abcrf]

Thanks Paul. I set Combo33 to requery on Combo42's after update. This does seem to refresh Combo33, but to an empty set of values. Would the problem then be in how I'm querying from the tables?

 

[pbaldy]

It could be a mismatch between the bound column of the combo and the value expected by the query.

 

[abcrf]

Forgive my ignorance, here. The automatic setting for the bound column is "1". What should it read?

 

[pbaldy]

It's more about what data is in the first column vs what the query expects. Can you post the db here?