me.text1.value = me.mycombo.listindex + 1
otherwise I was getting the wrong employee.
>
>Doing that made it work except for the first employee whose list index is 0. When I use any other employee it works ok but if I use the first employee, it doesn't find them when the form refreshes.
What are you using to restore to select the correct employee again? I noticed that the ListIndex property is read-only (I am used to VB where you can change it)
Whatever you are using, try saving it without adding 1 and setting it back to the saved value + 1.
I am using:
Me!MyCombo.Value = Me.Text1.Value
to restore the employee.
Here's to alcohol...the cause of ... and solution to ... all of life's problems - - Homer J. Simpson