controlsource = empid >rowsourcetype = table/query >rowsource = sql statement>
myInt = me!mycombo.ListIndexAnd restore it by assigning the myInt var back to ListIndex for the new record. Also I was thinking, you could use a bookmark for this. With a bookmark you don't worry about somebody else adding an employee in another workstation and throwing your listindex out of synch (that is, if you are reloading the employee table each time).