B
Bret
I currently have an Access 2002 frontend / SQL 2000 backend program. The
program uses pass-thru queries to populate 5 listboxes in one of my forms.
(average 6 columns of 20 - 50 records).
I use the query name with the rowsource property
(ie: .lst_Revenue.RowSource = "sp_Performance_Master")
I would like to see if there is a faster more efficient way to populate this
data, though its considered fast (15 - 20 seconds to fill form), I'd like it
faster if possible.
Is there a better way thru code to populate these listboxes to increase
download time? I realize their maybe other factors: network, server
performance, form design etc.
thank you.
program uses pass-thru queries to populate 5 listboxes in one of my forms.
(average 6 columns of 20 - 50 records).
I use the query name with the rowsource property
(ie: .lst_Revenue.RowSource = "sp_Performance_Master")
I would like to see if there is a faster more efficient way to populate this
data, though its considered fast (15 - 20 seconds to fill form), I'd like it
faster if possible.
Is there a better way thru code to populate these listboxes to increase
download time? I realize their maybe other factors: network, server
performance, form design etc.
thank you.