About the Data combo box

I have a dataCombo box and two ado control and text box. The datacombo box is used as lookup for the text box.


each time the form is loaded, I would like the recordset for the RowSouce of the datacombo box be filtered so that the user has the limited choice. I also want to have the normal add function. But the problem occured each time I do the add (like adodc1.recordset.addNew)


My question is that the two ado control one for the master recordset and another for the lookup recordset. If I want to filter the lookup recordset, should I filter the master
first?

Thanks for reading and If you have time, give me a tip