>>>>>>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?
>
>You can use actual dbf alias.

Still not there yet. In the cmdbut I have:
offyear='office'+myear
thisform.mylistbox2.rowsource='&offyear'

So that offyear can equal a dbf something like office97,office96,or office98.
What should I put in the property section of listbox2 in the rowsource and the rowsourcetype?