Auto-filling fields with table info

[gcomp]

This problem has reared its ugly head before and I've been able to work around it. Now I need this to work. Table fields are PartNumber, Model and Description. PartNumber is filled in via a drop down. Model is filled in with [PartNumber].[Column](1). Model fills in just fine, but Description is blank. Model is the 2nd column over and Description is the 3rd. I am trying to fill in Description with [PartNumber].[Column](2). This is how the SQL statement looks:
SELECT InventoryData.PartNumber, InventoryData.Model, InventoryData.Description
FROM InventoryData
ORDER BY InventoryData.PartNumber;

What am I doing wrong?

 

[boblarson]

Did you make sure to change the combo's COLUMN COUNT property to 3?

 

[gcomp]

Oops, I know it had to be something simple. Thank you very much.