RecordSet Max Size?

[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...

 

[Dirk Goldgar]

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

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.