Progressbar control

Hi,
I am trying to display the status of a recordset whilst it is processing data in a progressbar control. I do not know the property of the of the recordset to use. Any help would be much appreciated. Thanks

PS.Progressbar1.value = rsData. 'Do not know property

Albert

[Mark Sreeves]

if you are using DAO
ProgressBar1.Value = rsData.PercentPosition

if you are using ADO you'll need to use

'size the progressbar first
rstdata.movelast
ProgressBar1.max = rstData.RecordCount
rstdata.movefirst



'then use this within your loop
rsData.AbsolutePosition