>I sure wish there was a simple way to give a listbox a SQL statement and have it own the data. I do not need or want the cursor it creates.
>

A lot of us think that the array RowSourceType is the easiest to work with and most flexible. Declare the array as a property of the listbox and put your query into the array property in the Requery method.

Tamar