button Refresh

[azhar2006]

Hello all
I have a button on form I want is me to work (Me.Refresh)
But like the closing and opening of the form

[June7]

Do not understand the issue. What is your code and why doesn't it work - error message, wrong results, nothing happens?

What do you mean by "like the closing and opening the form"? What exactly do you want to happen when button is clicked?

[azhar2006]

OK
Thank you very much for your reply
This is two examples of what I want
1.
Private Sub Command39_Click()
Me.Refresh
End Sub
2.
Private Sub Command39_Click()
DoCmd.Close
DoCmd.OpenForm "frmCompanies", acNormal
End Sub
The second code is what is now used
Question
Is there something similar
That's where (frmCompanies) is the same as the form that it button

[Missinglinq]

You don't want Me.Refresh...you want Me.Requery.

Linq ;0)>