>>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()