>I have a form with two list boxes, DocType and SubType. I would like to populate SubType based on one of three choices in DocType. I have setup a table to contain choices for the SubType box. The table contains two fields: DocType and DocSubType. I thought I would setup an SQL statement in the RowSource of the SubType list box.
>
>Can anyone tell me if this is a correct way to do it, and what would the SQL statement be? I also have to do this same thing on an Access form. Will the same procedure work in Access? Help appreciated.
>Thanks
>
>
>Elgin Rogers Jr
>Epic Solutions.

Elgin, you have the first half correct. The second half is to refresh the SubType listbox from the InteractiveChange method of the DocType listbox. That way when the user picks a new choice the second listbox will be updated.

I'm assuming that you have a form property or global variable that is being used in the SQL of the second listbox, and that you can update this value in the InteractiveChange of the first listbox.

HTH