[AccessD] Using the recordset of a list control

When you say "scan each of the record"...are you only adding the ones 
selected?

>From: "philippe pons" <phpons at gmail.com>
>Reply-To: Access Developers discussion and problem 
>solving<accessd at databaseadvisors.com>
>To: accessd at databaseadvisors.com
>Subject: [AccessD] Using the recordset of a list control
>Date: Wed, 22 Aug 2007 19:24:36 +0200
>
>Hi all,
>
>I have a form with a list control.
>The list displays quantities and amount.
>Under the list, I have some text box that should display the total of these
>quantities and amount.
>
>What I do is to use the recordset of the list, to scan each of the record
>and do the sum I need.
>
>The problem is that this recordset does'nt seem to be reliable.
>Sometimes it does'nt exist anymore, sometimes it has 250 rows instead of
>just 5 to 10.
>The calcultaion is ok only the first time i do it, and then it's not!
>
>Did you already get into these kinds of troubles?
>What am I doing wroung?
>
>TIA,
>Philippe
>--
>AccessD mailing list
>AccessD at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/accessd
>Website: http://www.databaseadvisors.com

_________________________________________________________________
Find a local pizza place, movie theater, and more….then map the best route! 
http://maps.live.com/default.aspx?v=2&ss=yp.bars~yp.pizza~yp.movie%20theater&cp=42.358996~-71.056691&style=r&lvl=13&tilt=-90&dir=0&alt=-1000&scene=950607&encType=1&FORM=MGAC01