Returning whole recordset based on selection from combo box

[Sue]

I have some data entry forms accessing a large set of records. I am able to
jump to a specific record based on a selection from a combo box (by using the
wizard). However, I need the whole recordset returned and will be able to
navigate through these records and making updates as appropriate. How would
I do this? Thanks.

 

[niuginikiwi]

Hi Sue,

Combo gives you are specific record but if you want to view the whole set of
records then it might be a burden for the application to load the whole set
if you have a fairly large record.
You could either do this by filtering between a date range, or maybe some
common data like supplier or customer etc to get a handful of records instead
of trying to load a huge amount of data and browse through them.
I think some access version (?) load only the first 1000 records by default.

 

[Gina Whipp]

Sue,

Perhaps this is what you need... http://allenbrowne.com/ser-62.html

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm