Returning whole recordset based on selection from combo box

  • Thread starter Thread starter Sue
  • Start date Start date
S

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.
 
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.
 
Back
Top