 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Forms Programming / November 2005Help With COMBOBOX PLEASE!!!!
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.  Signaturehth Al Camp Candia Computer Consulting - Candia NH http://home.comcast.net/~cccsolutions > Hi there, > I have couple of forms which need to be filtered before user [quoted text clipped - 7 lines] > situation now so i dont have to worry later on......or is there any other > method which can give same result..... 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, > There are many ways... one is to limit the combo to say... contacts [quoted text clipped - 17 lines] > > situation now so i dont have to worry later on......or is there any other > > method which can give same result..... 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. Signaturehth Al Camp Candia Computer Consulting - Candia NH http://home.comcast.net/~cccsolutions > hi camp, > thanks for the response. I understand that to limit the combobox I [quoted text clipped - 40 lines] >> > other >> > method which can give same result..... |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.