Problem with synchronization

[DomZ]

Hi,
(Using Access 2002)
I've used both http://support.microsoft.com/default.aspx?scid=kb;en-us;209576 and http://support.microsoft.com/default.aspx?scid=/servicedesks/webcasts/wc080300/wcblurb080300.asp
to try and make synchronized combo boxes.
Here is my problem.

Here is the layout of my 2 tables.
TblClients:
----------------------------
ClientID
CustomerID (PK)
CompanyName
Address
ShippingAddress
City
Province
Country
PostalCode
PhoneNumber
FaxNumber
Others

TblPieces:
----------------------------
PieceID (PK)
CustomerID
PartNumber
Dimension
BaseMetal
Finish
Thickness
Specifications
Process
Line
Special
Price
Gage
Unit
Picture

What I want is that when I click on the combo box named cboCustomerIDParts, I see all the pieces in the combo box cboParts from the company selected in cboCustomerIDParts. However, Using both methods, When I click on a Company in cboCustomerIDParts, cboParts stays blank. It looks like it doesn't filter... The example in http://support.microsoft.com/default.aspx?scid=/servicedesks/webcasts/wc080300/wcblurb080300.asp for synchronizing is really similar to my situation....

I dunno what could be wrong.
PS: The name of the form where I use these combo boxes is FrmClientsPieces
Thanks

 

[llkhoutx]

Filter the records in the 2nd combo box by the value of the first combo box.

 

[DomZ]

Thanks for replying
What do you mean exactly?
Really need to get that working....
It is one of the main key in this database

 

[llkhoutx]

Look at the attached mdb, particularly the form and the VBA code associated with it.