Why cannot REFRESH -- FORM

[Martin]

In a form, I create a button which is used for refreshing this form ( this
button's refreshing funtion is leaded by the Access leading guide)

However, to my surprise, when I click it, the access shows me cannot
refresh. Why ??? ( in this form, I set up a lot of automatically
caculating TEXT box sourcing from the table information)


Thanks!

 

[John Vinson]

In a form, I create a button which is used for refreshing this form ( this
button's refreshing funtion is leaded by the Access leading guide)

However, to my surprise, when I click it, the access shows me cannot
refresh. Why ??? ( in this form, I set up a lot of automatically
caculating TEXT box sourcing from the table information)


Thanks!

Please post your code.

John W. Vinson[MVP]

 

[Martin]

The click button event code generated by the Access itself is:


Private Sub Command358_Click()
On Error GoTo Err_Command358_Click


DoCmd.DoMenuItem acFormBar, acRecordsMenu, 5, , acMenuVer70

Exit_Command358_Click:
Exit Sub

Err_Command358_Click:
MsgBox Err.Description
Resume Exit_Command358_Click

End Sub

 

[Dirk Goldgar]

In a form, I create a button which is used for refreshing this form (
this button's refreshing funtion is leaded by the Access leading
guide)

However, to my surprise, when I click it, the access shows me cannot
refresh. Why ??? ( in this form, I set up a lot of automatically
caculating TEXT box sourcing from the table information)

What is the exact error message -- or English translation of the error
message -- that Access displays when you click the button?