Access 2000.
Sql Server
I know this is going to sound crazy but I have a continuous form which
is bound to a sql table with an ODBC connection.
I filter the records in the Continous form based on the selection from
the previous form. At first moving through the records using the
scroll bar on the right was slow. I placed an option button on the
continous form which filtered the data to only show records that had a
quantity amount ordered.
I clicked the option button for only records with quantity ordered and
the filter produced no records because on this particular order their
hadn't been any activity. When I click the option button again which
brings back all records I notice that the scroll bar ran through all
the records as fast as you could scroll down.
So on the form open I do a filter where I know it will produce no
records then I do the normal filter and the speed in which I can go
through the records is amazingly fast.
Has anyone else notice this or why it does this or am I going crazy.
Thanks
Ray |