Hi guys
how do I add a refresh button to the form I used this code
DoCmd.RefreshRecord
and
Me.Refresh
but not working any solutions
thanks
Hi guys
how do I add a refresh button to the form I used this code
DoCmd.RefreshRecord
and
Me.Refresh
but not working any solutions
thanks
What event have you placed the code in? Try ON CURRENT.
What, exactly, does 'not working' mean? Are you getting an error message?
What, in plain language, are you trying to accomplish?
The Refresh method is designed to allow you to view changes that have been made to the current Recordset, by another user in a multi-user environment, since you loaded your Form. It only shows changes made to Records that were in the Recordset when you loaded the Form. It won't include Records that have been added or exclude records that have been deleted since the Form was loaded. To do that you have to Requery the Form.
Linq ;0)>
The problem with making anything foolproof...is that fools are so darn ingenious!
All posts/responses based on Access 2003/2007
Yes
Matcol true Missinglinq
I can not see to update the records, except in the case of the closure of the form and re-open it again
This is what happens
Thank you
As Linq said, Refresh only shows changes to records already in the form RecordSource. Use Requery to retrieve new records created by other users or by code.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
Hi
I put a button on a form is closed and opened at the same time
Something like this
Private Sub Command124_Click()
DoCmd.Close
DoCmd.OpenForm "frmStudent", acNormal
End Sub