How to refresh a form in access?

Question

I’m trying to make a refresh to a form, avoiding close it to open it, and thought of this function. However, without success. How can I do this procedure?

Public Fuction (f As a String)    
    Forms(f).Recalc    
    Forms(f).Refresh    
    Forms(f).Repaint    
End Function

Answer 1

Create a Macro, which already has this Update feature and references such a macro to a button.

It was created as an example, a macro with the name of Macro1, and your command Atualizar.

Guidebook: Create and Macro button

After this macro creation, do the following put a button on your form screen, and on the tab Event at the event Ao clicar choose the Macro1. Ready.

Answer 2

I was in the same trouble.

That’s how it worked:

Forms!NomeForm.Form.RecordSource = Forms!NomeForm.Form.RecordSource