Looks like I fixed it. I copied all the controls in the form and moved them to a new blank form, then copied all the corresponding vba code over. It all works now. Crazy!
Really makes me wonder whats going on in the background with two identical forms, one worked, broke, and the copy works flawlessly.
Apparently this random corruption has been happening since Access 2007.
To answer your question June7, this is not a multi-user db, or split design. Just developing this on my terminal at work.
The code in the OnChange is:
Code:
Private Sub CBO_CapSize_Change()
Me.CBO_Part_Set.Requery
Me.CBO_Part_Set.Value = ""
End Sub
Private Sub CBO_Machine_Type_Change()
Me.CBO_Part_Set.Requery
Me.CBO_Part_Set.Value = ""
End Sub
Private Sub CBO_Part_Set_Change()
Me.TXT_AssemblyID.Requery
DoCmd.Requery "Q_Subassemblies_SubF"
End Sub
these work together for the selections that narrow down the results for the comboboxes.