how to refresh pivot table data programatically

[ravindarjobs]

hello friends,
i am using ms access 2003, vb6.

i want a pivot table get refreshed automatically when i open it.

how can we refresh data in a pivot table programatically .

thanq

[lee123]

can't you use the

me.refresh in you code