>To obtain the index of the selected item in a combobox, use the ListIndex property. So when the user presses post, save the selected employee with:
>
>
myInt = me!mycombo.ListIndex
>
>And 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).
>
>
>
>
>I tried your suggestion in the following manner. When the user presses post, the listindex is saved to a textbox.
>
>
me.text1.value = me.mycombo.listindex
>
>I had to change this to
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.