Auto-filling fields with table info

gcomp

Registered User.
Local time
Today, 04:23
Joined
May 28, 2010
Messages
45
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?
 
Did you make sure to change the combo's COLUMN COUNT property to 3?
 
Oops, I know it had to be something simple. Thank you very much.
 

Users who are viewing this thread

Back
Top Bottom