button to refresh form 2

[hinchdog]

does anyone know a way to make a button to refresh a form. this is to avoid having to close the form and re-open it. i'm very new to access so please be gentle. thanks!

-hinchdog

 

[krispi]

What if you add a line to your code which sets the focus to a field on the correct tab on your form:something like

me!FldOnCorrectTab.SetFocus

Don't know if this would work but worth a try...

Chris

 

[fule12]

hi,Cheers
i have form(order) with combobox(suppliers)
I make on duble clik on combobox is open new form...so there i enter new suplier and on exit button i this code:
------------- start code------------
Private Sub cmbExit_Click()
On Error GoTo Err_cmbExit_Click

DoCmd.Close
Forms![Order].Refresh

Exit_cmbExit_Click:
Exit Sub

Err_cmbExit_Click:
MsgBox Err.Description
Resume Exit_cmbExit_Click
End Sub
----------end code--------------
So when i look in my combo box new supplier is there!!!!
I think same you can do with your main forme.If I understud correctly. Fule

 

[damienwjking]

Awesome.
What a relief. It works perfecto.
Cheers mate