[AccessD] Combo Box RowCount

Arthur,

Could you take the RowSource of the combox box (SQL) then put a WHERE clause
to represent the filter?  Maybe I'm missing something.

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Arthur Fuller
Sent: Saturday, January 24, 2009 11:46 AM
To: Access Developers discussion and problem solving
Subject: [AccessD] Combo Box RowCount

I'm debugging a form that has two combos that are used to search the data.
These are supposed to refresh their rowsource following a Filter. The
current filter is "City Like 'Toroonto*'", which returns 278 rows. I want
to verify that the refresh code is working. Is there a simple way to
determine how many rows there are in a combo?

Thanks,
Arthur
-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com