Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Updating a bound combo box
Message
De
12/09/2001 14:00:09
 
 
À
12/09/2001 12:34:41
Information générale
Forum:
Microsoft Office
Catégorie:
Access
Divers
Thread ID:
00554864
Message ID:
00555614
Vues:
12
This message has been marked as a message which has helped to the initial question of the thread.
>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.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform