>
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.
OK, instead of using ListIndex directly and assuming that the bound column is the employee id, use this to save the employee id:
me.text1.value = me.mycombo.itemdata(me.mycombo.listindex)
And restore it with:
me.mycombo.value = me.text1.value