listbox problem

[Filips Benoit]

Dear All,

Selecting 1 order in a listbox by code. Works OK, BUT
Opening a related form using Me.LstOrders.Column(0) as criteriavalue
sometimes triggers an error:
'There was a problem accessing a property or methode of the OLE object'

MsgBox Me.LstOrders.ItemsSelected.Count
MsgBox "[ORD_ID]= " & Me.LstOrders.Column(0)

When i insert these MsgBoxes before opening the form it shows:

1. If no error follows:
1
[ORD_ID]=1111
2. if error follow
1
[ORD_ID]=

In case 2 the selection is there but the value Me.LstOrders.Column(0) is not
accessible.

But why is it sometimes not accessible.

Reselecting the order manualy solves the problem.

THANKS,

[Ben Eaton]

Oh the joy of list boxes in Access - not a lot you can do except check to
see if the list box has a value in it before attempting to extract anything
from the Column property. This can be done by checking the listbox with
Isnull. For example:

If Not IsNull(lstOrders) Then
MsgBox lstOrders.Column(0)
End If

But to answer your question, I've no idea why Access is so fickle with
listbox selection :-/

"Filips Benoit" <be***********@pandora.be> wrote in message
news:VJ**********************@phobos.telenet-ops.be...

Dear All,

Selecting 1 order in a listbox by code. Works OK, BUT
Opening a related form using Me.LstOrders.Column(0) as criteriavalue
sometimes triggers an error:
'There was a problem accessing a property or methode of the OLE object'

MsgBox Me.LstOrders.ItemsSelected.Count
MsgBox "[ORD_ID]= " & Me.LstOrders.Column(0)

When i insert these MsgBoxes before opening the form it shows:

1. If no error follows:
1
[ORD_ID]=1111
2. if error follow
1
[ORD_ID]=

In case 2 the selection is there but the value Me.LstOrders.Column(0) is not accessible.

But why is it sometimes not accessible.

Reselecting the order manualy solves the problem.

THANKS,