Changing Row Source on Combo Box

[Stacey]

I have a main form that contains client data including a client number. The
main form has a subform that contains test prices. I have a default price
list and a special quotes price list:

rftbl_SQPriceList
rftbl_PriceList

The combo box in the subform contains the test code and the price
information based on the default price list. I need to be able to change the
row source of the combo box depending on the client number that is entered
into the main client form. Any suggestions please?

 

[Ofer]

You can have a look at this link, it will give you one option.
It gives you an example hoe to change the rowsource of one combo, based on
another combo, change it to a field

http://www.microsoft-accesssolutions.co.uk/filter_combo_boxes.htm