>have a table that has many deleted records and very few active records. there are several deleted records before you get to the first active record. this table is the recordsource for a grid. the grid (and the browse window for that matter) shows only the active records but the scroll bar is pulled down (not at the top). is there anything i can do to make the scroll bars reflect only the displayed records? know that i can do a pack, but the pack will make me lose my recordsource and would prefer another work around.
>
>thanks
>
>brenda
Create a view that extracts only the records you need, then use the view for the grid.
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer