You're overwriting the rowsource of the grid everytime you do a select, thus blanking it out. Instead of a temp table, how about using a parameterized view? Then you can set the parameter to whatever the combobox selected, and requery the grid to display the new information.