Auto Refreshing a subform

[mansonpj]

I am trying to get a subform to auto refresh after a period of time, at the moment the subform works of q query and once the main form is updated the subform updates.

I need the sub form to automatically refresh say every 10seconds or so.

Paul

 

[pono1]

Paul,

Search on Timer and Refresh in the Access Help file for explanations and example code. Warning: If this is a network app and your subform's holding thousands and thousands of recs, you could see a bit of a time lag when refreshing.

Regards,
Tim