Refresh button in form

[azhar2006]

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

[alansidman]

What event have you placed the code in? Try ON CURRENT.

[Missinglinq]

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)>

[azhar2006]

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

[June7]

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.

[azhar2006]

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