Run Time Error Issue- Improper Property Value

[Logit]

I've run into a problem that has me stumped. Run the attached file ...

Click "Open Form" (top of screen)
In "Search" field (top of form) enter the letter "J"

I receive a Run-Time error 380 (refer to attached image)

Oddly, if I click "Fill All Records Into Listbox" first, then click "Unload Listbox" ... then enter a search phrase in
the "Search" field, the program runs as intended.

I suspect by filling the listbox with all of the records first, prior to doing a search, that places all of the records into
memory which is what the program then uses when doing a follow up search and avoiding the error.

How do I correct the programming error without first displaying all of the records in the Listbox when the form is
initialized ?

Thank you for all of your assistance.

ps: I apologize for having to zip the file .... I don't understand why it is almost 2 mb for such a simple project.

[steve.smith]

Hi Logit,

For an unbound data source, there is a 10-column limit (0 to 9)

[Izandol]

Is only limit when you use AddItem. If you will load array into List or Column property this limit will not apply.

[Logit]

Thank you for your assistance. I was not aware of the Listbox limitation. This is a self-learning exercise for me.