Question regarding combo box values.

FunkyFlea

Registered User.
Local time
Today, 10:57
Joined
Mar 27, 2007
Messages
10
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.
 
Did you delete your other thread?
 
I undeleted it, Paul. So, it's back.
 
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 ">=".
 
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 :D
 
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.
 
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.
 
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.
 

Users who are viewing this thread

Back
Top Bottom