Richard, I have the cascading combo boxes working, thanks. I have an issue on my form where I have provided the users a button to reset the form if they have enter incorrect data. But after selecting the reset button the form resets but my cascading combo box will not reset/requery and is set to the last query selection. S the selection is limited to the last selection. The only way to clear this is to close and reopen the form. What should I do to correct this problem? Here is the code for my reset button:

Private Sub Command224_Click()

On Error GoTo Err_Command224_Click

     DoCmd.RunCommand acCmdUndo

Exit_Command224_Click:

    Exit Sub

Err_Command224_Click:

    MsgBox Err.Description

    Resume Exit_Command224_Click

End Sub

Thanks Lance

---

Reply from Richard Rost:

How about setting the combo box values to NULL and then issuing a requery?