I think that would work but am not sure of the syntax. The textbox
controlsource = empid
rowsourcetype = table/query
rowsource = sql statement
I don't know how to reference the index. TIA
Here's to alcohol...the cause of ... and solution to ... all of life's problems - - Homer J. Simpson