Form refresh

[Guest]

how do i get a form to refresh automatically or when it becomes the focus,

thanks for your help

Phil

 

[Ron Hinds]

Add this line to the form's Activate event:

Me.Refresh

 

[papa jonah]

I am search of something similar - I think.
I have a form with two radio buttons that I hope will one day dictate
how the records on the form are sorted.
Currently they are sorted by "designator". The radio options are to
allow the user to sort by either the designator or by "date". I can
manually do this just fine.
Here is the code that I have put in the afterupdate and also in the
after click events for the radio button group:
Private Sub optSort_AfterUpdate()
If optSort = 2 Then
Me.OrderBy = "Designator"
Else
Me.OrderBy = "discovery_date"
End If
Me.Refresh

End Sub

However, it does not seem to matter which radio button is clicked. The
form properties sort value updates but the form does not.