I have successfully used the method shown in the extended video and prefer it over adding multiple formal queries.  However, I am not getting the proper updates when I make my front end into an .accde file.  

This is true regardless of which method I choose.  The ACCDB file works just fine, but the ACCDE file doesn't update properly.  Both files use the same backend ACCDB file.

Here is my code:
------------------------
Option Compare Database

Private Sub Form_Current()

    Combo_Room_ID.Requery
    
End Sub

Private Sub Combo_Building_ID_AfterUpdate()

    Combo_Room_ID.Requery
    Combo_Room_ID = 0
  
End Sub
-------------------

Is this just an issue with using ACCDE files, or am I missing something on updating cascading combo boxes?