Refresh form button in access 2010
Posted on 2012-08-23
Hi. I have form which includes multiple tabs. One of the form tabs reflecting calculations.
Issue: data was not constantly stored in the database after I adjust field "x" or field "z"
See below: field "y" = field "x" + field "z" (of course I mean values)
form field "q" taken from the source query which involves value of the field "y"
I have button to refresh form data with the following code "DoCmd.DoMenuItem acFormBar, acRecordsMenu, 5, , acMenuVer70"
I suggested to replace above listed code with Me.Refresh
Question: would you please tell me wheter above listed code <b>"DoCmd.DoMenuItem acFormBar, acRecordsMenu, 5, , acMenuVer70" </b> is correct and reliable? Can we use such code at any time or we have some limitations?
Per my opinion, the code Me.Refresh or Me.Requery is more sofisticated in order to refresh data in the form using calculated fields.