>>>>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"
>
>Yes you can use cmdbutton too. The right syntax, assuming that whatyear is cursor name, is:
>thisform.mylistbox2.rowsource='whatyear'
Actually I've not used cursors in forms. All a cursor is is a temporary database so would it make a difference to use the actual dbf?
"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."