Search results

I see what you mean; 2000 does seem like alot. I'll need to offer them the ability (via combo boxes) to further restrict the dataset. What do you think of specifying default selections in several criteria-selection combo boxes when the form opens up? (Ex: Account age ("> 30 days"), insurances...

Hi: I have built an Access 2000 front end that displays data from a backend SQL database. The recordset is returned via a vba pass-through query, and since I send over all the criteria to the server (in a parsed 'Where' statement) the data is returned with very good performance. My problem...