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.