refresh a subform

[Faction21]

How do you refresh a subform? I have a button which processes data and exports it, then deletes all records in the table. this table is the one on the subform(in datasheet view), and all the records say #DELETED, and I cant get them to refresh. This is what Im using now.

Private Sub Refresh_Click()
On Error GoTo Err_Refresh_Click


DoCmd.DoMenuItem acFormBar, acRecordsMenu, 5, , acMenuVer70

Exit_Refresh_Click:
Exit Sub

Err_Refresh_Click:
MsgBox Err.Description
Resume Exit_Refresh_Click

End Sub

What is the command to refresh a subform properly?

-Thanks

 

[Faction21]

Never mind the button attempt! Im trying this but its not working!

How does the syntax go for this?


Private Sub Form_Timer()
Forms!frmProcess!Process_subform.Form.Refresh
End Sub

I got frmProcess as my main form, Process_subform as my subform. But I get an error that says 'Field Process_subform not found'

 

[ChrisO]

G’day Faction21

This may help you overcome many such problems.

Hope that helps.

Regards,
Chris.