>>Wes,
>>
>>Are you calling the Listbox's Requery method after you issue the SQL? You must do that to get the listbox to refresh it's internal list of items.
>
>Jim,
> I'm not calling the Requery method. What do I need to set the method to?

Weston,

You don't need to set the emthod to anything, just call it after you run the query as in;

SELECT ...
Thisform.List1.Requery()