RecordSet Max Size?

  • Thread starter Thread starter Ardy
  • Start date Start date
A

Ardy

I have a form using the following lookup to list ascending
order of a last name field from a table with about 67000
records.

Me.RecordsetClone.FindFirst "[c_no] = " & Me![Combo44]
Me.Bookmark = Me.RecordsetClone.Bookmark

When the lookup window is openned, I am only able to view
about 65000 records? Last names listed are from A to about
W. , but not able to look for names starting with X, Y, or
Z. However, I can type the full name and find the record!

is the records set running out of space? If so, how can I
increase the size of the recordset space? Or is this some
limitation on the forms display window?

Thanks...
 
Ardy said:
I have a form using the following lookup to list ascending
order of a last name field from a table with about 67000
records.

Me.RecordsetClone.FindFirst "[c_no] = " & Me![Combo44]
Me.Bookmark = Me.RecordsetClone.Bookmark

When the lookup window is openned, I am only able to view
about 65000 records? Last names listed are from A to about
W. , but not able to look for names starting with X, Y, or
Z. However, I can type the full name and find the record!

is the records set running out of space? If so, how can I
increase the size of the recordset space? Or is this some
limitation on the forms display window?

Thanks...
Click to expand...

It's not the recordset, it's the combo box that is limited. -- to 64K
entries. A lookup list that big isn't much good as a user interface
device anyway. I suggest you use some other control first to limit the
list to a smaller subset -- for example, by having the user first type
in the first letter of the name, and then setting the combo box's row
source to a SELECT statement that extracts only the names that start
with that letter.
 
Back
Top