An Easy one for you vets

[benu302000]

Ok, How do I get a subform to refresh it's contents? I know its called requery, but how does that work? and is there a way to do it continually, or every so often?

 

[kjv1611]

Using a timer control, possibly:

Private Sub Form_Timer()
   Form.Requery
End Sub

That would be my guess, and just put it on your subform, not main form. The code would be the exact same, so long as you have the timer event on the same form you are requerying.

Stephen
"Jesus saith unto him, I am the way, the truth, and the life:
no man cometh unto the Father, but by me." John 14:6 KJV

 

[TheAceMan1]

How are ya benu302000 . . . . .

[blue]For single/mainform:
[purple]Me.Requery
Forms!FormName.Requery[/purple]

For subForm 1 level deep:
[purple]Forms!FormName!subFormName.Form.Requery[/purple][/blue]

As already suggested by [blue]kjv1611[/blue] you can use the [blue]Timer Event[/blue]

Whats causing you to have to continually refresh?

See Ya! . . . . . .