Question regarding combo box values.

[FunkyFlea]

Hi,

I have a combo box acting as a filter for a form with the following row source:

1;2;3;4;5;6;7;8;9;10;11;12

It is related to a field which has the following VB code:

If Not IsNull(Me.cboFilterPeople) Then
strWhere = strWhere & "([AvailableNoTickets] = " & Me.cboFilterPeople & ") AND "
End If

...basically I need the combo box to offer values of 1-12 but only return results if the value selected is less than the the value in the corresponding field.

Thanks.

 

[pbaldy]

Did you delete your other thread?

 

[boblarson]

I undeleted it, Paul. So, it's back.

 

[pbaldy]

Thanks Bob; I clicked on my email to go to it and got the "invalid thread" message.

Funky, I would think your answer here is to replace "=" with ">=".

 

[FunkyFlea]

Thanks Bob; I clicked on my email to go to it and got the "invalid thread" message.

Funky, I would think your answer here is to replace "=" with ">=".

(I deleted it as resolved...sorry thought i was doing a good thing. Nevermind.)

That simple? I'll give it a go!

Edit: That works. Thanks. All my Q's resolved now

 

[pbaldy]

Forums like this serve in two ways. First, obviously you can ask a question and get an answer. Secondly, you can search to see if your question has been answered before, and find relevant threads. Deleting threads would completely negate the second.

 

[boblarson]

It would be GREAT if the forum software allowed you to mark a post resolved and that it showed in the list as a slightly different color, or something. I could skip a lot of posts if they were marked resolved. But, unfortunately, I don't know of any way to do that, at least with the vBulletin software. I guess we could lock the posts if resolved and that way the icon would show a lock, but there are times where people repost a long time later for a "tweak" to the posted response.

 

[pbaldy]

That would be nice. It seems like there was an earlier version that had that feature. I don't know if it was dropped or if it's simply turned off. I suppose one way would be for the OP's to amend their thread title ("Resolved-Original title here"), but it would likely not be done with any consistency.