Thanks to Angelo I've overcome my previous problem of updating combo box 2 depending on the value in combo box 1, but I now have another problem...

Combo box 2 doesn't hold the value that I select from it's list. It does present me with a list of suppliers depending on combo box 1 as required, but once I have selected the supplier the combo box goes blank.

Any ideas??

Thanks.

Sorted .. I had the 'bound column' property of the combo box set to 2 instead of 1.