Help With COMBOBOX PLEASE!!!!

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi there,
I have couple of forms which need to be filtered before user
can work on them. I am using cascaded combobox. Each form needs to be
filtered by a contract Number which then shows corresponding vendors for that
contract but my question is....I know that Number of contracts will keep on
growing which will make combobox too big in future...How should i tackle this
situation now so i dont have to worry later on......or is there any other
method which can give same result.....
 
LW,
There are many ways... one is to limit the combo to say... contacts
created during the the last six months, or a year, or whatever.
You could even have a Year combo before the Contract combobox that would
allow the user to select an "as of" year to filter the Contract combobox
accordingly. (having last year as the default for normal day to day
transactions, and select an older year only when rarely needed)
You could create a boolean checkbox field in your Contract table called
Inactive. When Inactive is true, that contract doesn't show up in your
combo any more.
 
hi camp,
thanks for the response. I understand that to limit the combobox I
would have to change the rowsource accordingly, but I didnt quite understand
how to use boolean checkbox field and would that help to limit the combobox
values....sorry about that...
another thing that I should have asked before too...what's the number of
values on average that a combox should be used to hold normally....is it okay
to use combobox to hold up to i will say 400 to 500 contracts, since i will
restrict this to yearly bases now i am thinking the maximum number of
contract it wil show will be around that number in any given year..
thanks alot for your help.
 
LW,
500 is no problem. Right now I'm using a combo with 850 names, and don't
have any problem with speed. AutoCorrect works just fine too.
I think you should filter your combo for Date() - 1 year, and that should
do it.
 
Back
Top