Re: Is there a way to keep 2 textboxes the same???

T L wrote:
^^^
Hmmm... :)

> [...] I have a form with a large table displaying values I extract from a
> database. I want to put some final totals from the table at the top of
> the form (ie: number of rows with value x). I would rather not create
> arrarys or loop thru the ADO recordset to calculate these values then go
> back (movefirst) and loop thru again to display. I thought about putting
> a hidden textbox at the bottom of the form that would update the textbox
> at top of the form. Maybe there is a better way to do this?

I have not used ADO much recently, but I think you want to do a query and
then use the Count property --

<URL:http://msdn.microsoft.com/library/en-us/ado270/htm/mdmscadoproperties.asp>

-- or simply use a variable that you increase as you iterate through the
recordset.

PointedEars
Received on Tue Feb 7 21:16:31 2006