Check for value in List Box

  • Thread starter Thread starter Silvio
  • Start date Start date
S

Silvio

Hello, I have the code below to compare a value from control vs. the content
of a list box (column 1), however it does not work. Any idea how to get it to
work?

If Me.DocumentsList.Column(1).Value = me.MyCompany Then
....

Thank you,
Silvio
 
Silvio said:
Hello, I have the code below to compare a value from control vs. the
content
of a list box (column 1), however it does not work. Any idea how to get it
to
work?

If Me.DocumentsList.Column(1).Value = me.MyCompany Then
Click to expand...


The listbox Column property doesn't have a Value property. Maybe this is
what you want:

If Me.DocumentsList.Column(1) = Me.MyCompany Then

Be aware also that in code, columns are numbered starting from 0, so that
the first column of the list box is .Column(0). If you intended to check
the first column of the list box, then you would need this version:

If Me.DocumentsList.Column(0) = Me.MyCompany Then

Of course, if the column you want to check is the list box's bound column,
then you don't need to refer to the .Column property at all:

If Me.DocumentsList = Me.MyCompany Then
 
Silvio said:
Hello, I have the code below to compare a value from control vs. the content
of a list box (column 1), however it does not work. Any idea how to get it to
work?

If Me.DocumentsList.Column(1).Value = me.MyCompany Then
...
Click to expand...

If your column 1 is the first column, then use Column(0)
 
Thanks guys but it does not work. Keep in mind that I DON'T make ANY
selection from the list box the evaluation process starts from the control
me.mycompany

I guess the list box need to be treated as record set??!!
 
Silvio said:
Thanks guys but it does not work. Keep in mind that I DON'T make ANY
selection from the list box the evaluation process starts from the control
me.mycompany

I guess the list box need to be treated as record set??!!
Click to expand...


I don't know about Marshall, but I don't understand what you're doing, or
what you're trying to accomplish, and you haven't said in what way it
doesn't work, so there is nothing to "keep in mind". May I suggest again
that you explain what "doesn't work" means to you, and what it is you want
to do, and then I'm sure we can solve your problem.

Your remark about treating the list box as a recordset hints at a
possibility for what you may intend, but you need to spell it out.
 
Back
Top