How to refresh a form in access?

2

I'm trying to make a refresh to a form, avoiding closing it to open it , and I thought about this function. However, to no avail. How can I do this procedure?

Public Fuction (f As a String)    
    Forms(f).Recalc    
    Forms(f).Refresh    
    Forms(f).Repaint    
End Function
    
asked by anonymous 07.07.2014 / 15:55

2 answers

2

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

A macro with the name Macro1 and its Atualizar command was created as an example.

Create and Macro Button

Afterthismacrocreation,dothefollowingputabuttononthescreenofyourform,andontheEventtabintheAoclicareventchooseMacro1.Ready.

    
07.07.2014 / 17:06
0

I was having the same problem.

So it worked:

Forms!NomeForm.Form.RecordSource = Forms!NomeForm.Form.RecordSource
    
27.03.2018 / 19:37