>>Is it possible to have a 2nd listbox's source control come from the selection of a 1st listbox? I'm sure it is for you veterans.
>
>That's not a problem. You should just 'reset' listbox2.rowsource in Listbox1.InteractiveChange event. Actual 'Resetting' depends on what RowSource you will use. I prefer to use cursor, and refill it each time user will pick up new value from the first list. Remember Listbox2.requery to get new appearance.
Hi. I could also put this into a cmdbutton as well right? Can you clue me in as to the exact syntax of the command? I've unsuccessfully tried:
"thisform.mylistbox2.rowsource=whatyear"
"Build a man a fire, and he's warm for a day.
Set a man on fire, and he's warm for the rest of his life."