[AccessD] Bound Forms Question

Jim Dettman jimdettman at verizon.net
Sat Feb 23 15:15:53 CST 2013


 Like any good answer; it depends<g>

 The number was never been pushed and I don't believe it's hard and fast.
Access/JET decides based on the record source if it will fully populate the
record set or not before returning to the form.

 That's why .RecordCount is not guaranteed to be accurate.  All you can
count on is if it's > 0, you have records.  To get an accurate count, you
force Access to populate the whole thing by doing a .MoveLast.

Jim. 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Arthur Fuller
Sent: Saturday, February 23, 2013 01:12 PM
To: Access Developers discussion and problem solving
Subject: [AccessD] Bound Forms Question

When Access opens a form bound to a table, how many records does it read?
All of them or just the first *n* rows? Does performance of the form relate
to the size of the table?

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



More information about the AccessD mailing list