>Hi,
>
>I am having a table with four fields.
>Key,Discription,FilterField1,FilterField2
>
>I am using this form to add, modify records in the master.
>I am having nearly 20 differnt fields on this form where
>I want to have all combo boxes. Now based on FilterField1 and FilterField2
>I want to display certain records in each combo box.
>
>One way is to create 20 different temp file for each combo box.
>This I have tryed and it works fine.
>
>Can I use the original file and set filter condition for combo boxes ?
You can set only one filter condition on the table. For multiple comboboxes you can use RowSourceType = 3 - Sql Select and Selects with different conditions as the RowSource.
--sb--