I have subforms on a form that have cascading combo boxes - when you open the main form, from another form via id = & id, the form and cascade combo box is fine. If you click the unfilter in the navigation box (so that you can step through each record) the next record won't show the correct value in the combo box. It seems to have the same value in the master combo box as the previous record (not refreshing or something) and so the second combo box won't show the result.
How do I get around this?
(ignore the Blank (before 2013) that is just the value of all old shows, also ignore SHOW field as that isn't required and unrelated.)
and as you can see the year is later and the second is blank
in the show combo box row source the query has forms!frmMain.Form!frmSub.form!cmbBookingYear