Display ALL records in a form?

[evander]

Hi everyone.



I have a table whose number of rows increases by 100 everyday. The form thru which this table is displayed is NOT set to Data Entry = Yes.

Is it proper to display all records in a form? Will it not crash the form? Or should I display a subset of the table data, by writing a WHERE clause in its query?

Hoping to get a response. Thanks everyone!

[jzwp11]

Access usually sets a default of 1000 records (Tools-->Options-->Edit/Find). You can increase the default, but why would you want your user to look through all of the records to find the ones they need? I would have an unbound form ahead of your main form that allows the user to filter the records. You would use the user choices selected in the unbound form to dynamically filter the main form's recordset to give the user just the records they want to see.

[evander]

Oh. That unbound form, I made it for filtering data that is passed onto a report. I'll do the same for the form itself then. Thanks budd!

[jzwp11]

You're welcome! Good luck with your project.