A2002 refresh error crash

[mark curtis]

Dear all,

I am using a converted 97 db in a2002,

I have a main form called frmDocumentRegister with a tab control on with many sub forms. I have placed the following in one of the controls and the db keeps crashing after update:

Private Sub ApprovedBudget_AfterUpdate()
Me.listbox206.Requery
Forms!frmDocumentRegister.Refresh
End Sub

I think the refresh is the problem but the code works fine in a97.

Any help please

Mark

 

[geralf]

mark,

It's the requery in the After update event which causes cascading updates. Try using Me.listbox206.Refresh instead of Me.listbox206.Requery.

Regards
Gerhard

 

[Pat Hartman]

Please don't start a new thread when you already have an open one on the same topic.