Hi,

I have a combobox with the following in its row source property:

SELECT [Surety Table].Surety_ID, [Surety Table].Name
FROM [Surety Table]
ORDER BY [Surety Table].Name;

This works fine and displays the Surety Table.Name values in the combobox when I click on it. I have added a command button that brings up a form that allows the user to input the data into the Surety Table and now I need to know how to make the combobox show the new entry in the Surety Table. How do I make the combobox requery the table?

Thanks,

Keith