"@ndy" <an*******@hotmail.com> ha scritto nel messaggio
news:6c**************************@posting.google.c om...
Hellow programmers,
does anybody has any suggestions for the next problem?
I'm looping a recordset and during the loop it allso calculate some
things.
Now I want display a POPUP FORM with PROGRESSBAR. The maxvalue is the
recordsetcount and every loop is value + 1. How can i pass these value
to the POPUP form. I've somthing with public tel but it won't work!
Thanx anyway
You have many way to do this, some of them:
1)Use OpenArgs like OpenForm Method Property(see on Help)
on POPUP Load Event you can get with Me.OpenArgs the value.
It's a String value, but clng(Me.OpenArgs), then set the Max.
2)Use a specific Form Property using Public Property
Private mMax as Long
Property Let Max(value As Long)
mMax = value
End Property
After POPUP is Open with Docmd.Open...... bla bla
Forms!PopupName.Max=Rs.RecordCount
Then on POPUP Form PBar Setting procedure :
Pb.Max=mMax
Bye.
--
@Alex (Alessandro Baraldi)
---------------------------------------------------------------------------
http://www.sitocomune.com/ http://www.mantuanet.it/alessandro.baraldi/
---------------------------------------------------------------------------