updating a form while processing data

[sparkyzx]

Hi,

Im trying to put a counter on the screen that counts records as they are processed by a recordset from the DB, but for some reason, VB waits until all the records have been processed until it updates the counter on the form.

Any ideas how to refresh the form after I process each record?

Thanks!
Matt

 

[Toyman]

I assume you use a label for the counter.....
Just add DoEvents after you set the label's caption to [RecordCount]

Cheers
Toyman

 

[MrSandman666]

There's also a thing called "me.Refresh". It's actually a method of a form. All it does is update the form while DoEvents processes ALL the events that come in while you're doing your database stuff. I'm actually working on exactly the same thing now (updating a counter on the form while processing a rather large recordset).

 

[JohnYingling]

Maybe every 100,
if lngcpount mpd 100 = 0 then lblCount.refresh

http://WWW.VBCompare.Com