Thanks for the response Marcia. My problem ended up being the screwy way I defined my indexes when I first setup the database, but the tips you gave me will really help me in the future.

I am having a different problem now. I'm using the combo box to display Users!user_id, Users!last_name, and Users!first_name. It looks as though the data in the combo box is displayed sorted by Users!user_id because that is the primary key for the users file. Is that right? Well, anyway I want to be able to sort the data in the combo box by Users!last_name + Users!first_name so that the user could type in the last name to search through the list. Is there a way to do this or will I have to set up a query?

Thanks for all of your help!
Van