flexi combo

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is there any way to automatically increment the selection of a combo box for
the successive record entries (by the end user) by incrementing the index
from their first manual selection? Is there any 'get index' command that can
be stored and updated at each page update? Also, this is a multi - user
environment so it should work independently for each user entering data.
Thanks for any suggestions
 
MS said:
Is there any way to automatically increment the selection of a combo box for
the successive record entries (by the end user) by incrementing the index
from their first manual selection? Is there any 'get index' command that can
be stored and updated at each page update? Also, this is a multi - user
environment so it should work independently for each user entering data.
Click to expand...


You can use the ListIndex property to do that. Note that
the combo box must have the focus when you try to set the
property.
 
Thanks. The listindex gives me the current index of the selection in the
combo. I saved it to a variable on Before Update event of Form. How do I use
this to select the variable + 1th position in the combo box for the next
record?
Thanks for any suggestions.
 
You should use the combo box's AfterUpdate event to save
ListIndex.

You can something like this in the form's Current event,
or, probably better, the Dirty event:

If Me.NewRecord Then
With Me.thecombobox
If .ListIndex < .ListCount-1
.SetFocus
.ListIndex = yourvariable +1
End If
End With
End If
 
Back
Top