DB corrupted?

[tcox]

I'm now presented this message when clicking on any of my list boxes.




This started happening when after I saved some VBA code in a function and Access alerted me that another user had edited the form and asked to save those edits. I was like , but I thought erroring on the safe side would be to save the edits.

Private Sub txt_SubassemblyNotes_Click()
DoCmd.RunCommand acCmdZoomBox
End Sub

Fairly innocuous code.

what has happened and where do I start to fix this?
My form was working perfectly until now!

[tcox]

I have tried the fix of copying the affected form, deleting the original and then renaming the copy to the originals name.. no joy

[June7]

Is this a multi-user db? Is it a split design?

Exactly what is in the OnChange event property of comboboxes? I don't use OnChange event. I use AfterUpdate.

[tcox]

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:

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.

[ssanfu]

What it sounds like is that the VBA project was slowly going bad (corrupting).

I had this happen in A2K. I made a lot of changes without doing a Compact & Repair.
My rule now is: Compact often..... Save often.
This means saving about every 5 minutes. Compact & Repair about every 10 lines of code added, deleted or changed.