Choosing A Secondary List In A Combo Box

[HectorTheInspector]

Hi, I have created a database to store all my car magazine information. I have an "Enter Data Form" where one of my entries is a combo box. The combo box is linked to the [car year] Table. When I click on the combo box side arrow I get the years "1930; 1940;1950, 1960 etc. I scroll to the year :say 1950 select it and then click back into the chosen field and manually change the '0' to '3'.... = 1953. I would like to automate this function further and scroll down the combo box list to; say 1950 and when highlighted it would open a secondary column with the years from 1951-1959... then I could choose 1953 and that would save me from manually having to change the last digit of the year. Would I be looking at using some kind of subform? Thank you for your help. regards Hector.

[June7]

Why not just type 1953 into the combobox? 4 fast key strokes as opposed to a bunch of scrolling and clicking.

Otherwise, review http://www.datapigtechnologies.com/f...combobox2.html

[HectorTheInspector]

Hi, thank you for your reply and you are probably right. But it didn't answer my question. Can it be done? Can you scroll down the column in a combo box and when you stop/highlight a line it will open another column in the same combo box (a second column beside it) that you can choose a line from? I will check out the link you supplied...... Thanks again, Hector.

[Missinglinq]

The answer to your original question is 'no.' As June7 said, trying to do this kind of thing in order to skip entering a 4-digit value is really inappropriate; in point of fact it would probably increase the work/time involved!

But if you had a valid reason for using hierarchical data, which is what you're talking about, here, you could use two Comboboxes, set up as Cascading Comboboxes. Using your scenario, when selecting 1930 from the first Combobox, the second Combobox would only show 1930, 1931, 1932, 1933...and so on:

Cascading List for Access Forms

Cascading Combo/List Boxes


Alternatively, you could use an ActiveX TreeView control:

Treeview Control Sample Downloads

Linq ;0)>

[June7]

I didn't explicitly say no, but implied with reference to a tutorial of what can be done. It's the same technique Linq describes.

[HectorTheInspector]

Thank you for your help. I have got my solution by using a second combo box. regards hector.