cascading combo boxes do not refresh on new record

[willfrank]

I have two combo boxes: Buildings and Rooms: I first select Buildings then Rooms. Combo boxes provides correct drop down based on first selection. Issue is when I go to new record, the combo boxes do not refresh. thanks

[ranman256]

in the ON CURRENT event, you must reset the combo boxes.

[willfrank]

thanks: I am new to access, can you please explain further: I know how to access the current, but not familiar with code etc..

in the ON CURRENT event, you must reset the combo boxes.