Multiple dependent combo boxes

[sclark]

Have been trying out several different solutions for multiple dependent combo boxes. As a neophyte, just can't seem to make it work. If anybody wants to take a shot I will send the zip file.

Thanks.

 

[jmrSudbury]

After update of the first box, enable and requery the second box.

John M Reynolds

 

[sclark]

Thanks for the tip. Finally got them working with some help. The requery seems to work fine. However, the info from the second and third combo boxes intermittently disappear on the form when navigating back and forth through all the records. The actual info is there, however, when I look at the master table. Curious.