Limiting Records

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

In an Access 2000 project, is there any way to limit the
number of records seen on a form, yet filter all the
underlying table's records? I have a form whose
underlying table has over 50000 records. I don't want to
see them all when I'm adding new records. However, I'd
like to filter against all 50000 records.

I've tried adjusting the max records setting on the form,
but any filter I enter only filters against the records on
the form, not all 50000 records in the table.

I've tried making the form a data entry form, but then I
can't filter at all.

Help!
 
Instead of using the table name as the record source, use an SQL
statement. Filter by changing the SQL's WHERE clause.
 
There are a lot of fields on my form that I'd like to filter by. I don't
want to end up building a query form. I'd like to be able to just use the
Filter By Form and Apply Filter buttons, but it doesn't look like I can do
that. Is there any way I can control the filter using Visual Basic?
 
See the Access VBA Help article Filter Property & the "See Also"
articles under Filter Property.
 
Thanks for your help. It looks like I can't easily do what I want to do. I
may just create 2 similar forms - one for adding records and one for
filtering records.
 
Back
Top