Requery for cascading combo boxes

[msmithtlh]

I have 2 combo boxes. The values available in combo box 2 are dependent on the value selected in combo box 1. This works fine for a new record.

However, if I change the value in combo box 1, the values available in combo box 2 are not correct for the new value in combo box 1.



I suspect I need a "requery" command. I have tried this, attaching it to different properties, but can't get it to work correctly. Which combo box and what property should the requery action be associated with???

If requery is not what is needed, please advise what is needed.

Thanks!!!!!!

[June7]

Use combo 1 AfterUpdate and/or combo 2 GotFocus as well as form Current events.

[ranman256]

sub cboBox1_afterupdate()
 cboBox2.requery
end sub

[msmithtlh]

Thanks!!!!!!!!!!!