PC Review


Reply
Thread Tools Rate Thread

Multiple dependent combo boxes

 
 
New Member
Join Date: Jun 2012
Posts: 5
 
      29th Jun 2012
Hi

I have a date field. I have two combo boxes. One for year and One for month.

I have already written code for the year combo box to show only the unique years represented in the date field.

I am now trying to make the month combo box show only months present in the year selected. Also the months need to be sorted from latest to oldest in each year.

For example:

Datefield
6/1/2012
5/1/2012
6/1/2011
4/1/2012
3/1/2011


Year combo box should show only 2011 and 2012.

If user selects 2011 for year then the month combo box should show June, March in that order

If user selects 2012 for year then the month combo box should show June, May, April in that order
 
Reply With Quote
 
 
 
 
New Member
Join Date: Aug 2012
Posts: 16
 
      1st Aug 2012
Have you tried using Data Validation? You need to create dynamic named ranges and use these as the source for the Data Validation, the drop down list in each field will then have the information you want. I can't remember exactly where I found the advice, but this link http://www.get-digital-help.com/2010...lues-in-excel/ should help.

Your requirements are entirely achievable.

Regards

Peter
 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Multiple dependent combo boxes vroedie@gmail.com Microsoft Access Getting Started 3 31st Jul 2006 03:46 PM
Continuous subforms, combo boxes, and making them dependent David Walker Microsoft Access Forms 3 26th Jul 2004 08:35 PM
Format Dependent Combo Boxes =?Utf-8?B?TWljaGVsbGU=?= Microsoft Access Forms 1 3rd May 2004 05:37 AM
Re: Combo boxes dependent on combo boxes Van T. Dinh Microsoft Access 0 21st Jul 2003 02:22 PM
Re: Combo boxes dependent on combo boxes Kevin @ 3NF Microsoft Access 0 21st Jul 2003 01:52 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 12:15 AM.