Listindex question

[Mattias]

Hi

I have used the below code with succes before when using it with the forms
"Before Insert" event.

Now using with controls AfterUpdate event I get runtime error 7777 "You used
the listindex proporty incorrectly"

Any help here is most appreciated

Mattias

Private Sub Artikel_AfterUpdate()
DoCmd.GoToControl "Auktion"
Me.Auktion.ListIndex = 0
DoCmd.GoToControl "Antal"
End Sub

 

[Mattias]

Hi thanks for replying,

It is not a multiselect box and what I want to do is get the top value in
the presorted listbox as a "default value" after this control is updated...

Mattias

 

[Ken Snell]

You could use either of the following options:


Me.ListBoxName.Value = Me.ListBoxName.ItemData(0)

or


Me.ListBoxName.Selected(0) = True

 

[Mattias]

Hi,

Tried the first one...works very well now!!

Thanks

 

[Marshall Barton]

don't know where and how did you use the code before, but the A2K Help
says, the ListIndex property is read only.

Since the question has been answered, I just thought I'd try
to clear up this confusion.

Help (all versions) is incomplete on this issue. It should
say something more like:

The ListIndex property is read only when the
list/combo box does not have the focus. It is
read/write when the list/combo box has the focus.

 

[Emilia Maxim]

Since the question has been answered, I just thought I'd try
to clear up this confusion.

Help (all versions) is incomplete on this issue. It should
say something more like:

The ListIndex property is read only when the
list/combo box does not have the focus. It is
read/write when the list/combo box has the focus.

Thank you, Marshall!

Best regards
Emilia

Emilia Maxim
PC-SoftwareService, Stuttgart
http://www.maxim-software-service.de