By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,482 Members | 2,411 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,482 IT Pros & Developers. It's quick & easy.

I must be crazy. Continuos Form bound to Sql table

P: n/a
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

Feb 12 '07 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.