get access runtime error -1517

[John]

I added a field to an Access 2003 database. The field is linked to another
table via a query "SELECT PlanAssetType.PlanAssetTypeDescription,
PlanAssetType.PlanAssetTypeID
FROM PlanAssetType
ORDER BY PlanAssetType.PlanAssetTypeDescription;"
The field is bound to column 2 and it is shown in a combo box.
(This is similar to another field on the table which is error-free). The
problem is, when browsing the table thru table linking, the linked value does
not show. If one clicks on the field, I get this error msg "reserved error
(-1517); there is no message for this error". And one has a hard time getting
rid of the error. Occasionally, users get the same error when trying to
modify the field (via form) and have to cancel the task to get out of it.
Additionally, sometimes the field has problems, sometimes not.

Any help would be appreciated. I know the desc is spotty, but I'm hoping
someone may have encountered it before and knows what I'm talking about.
Thank you.

 

[Ron Hinds]

Here is what that error means:

JET_errBadColumnId -1517 Column Id Incorrect

Now, how that applies to your situation. Possibly it is a data error in the
PlanAssetType table, e.g., a NULL value in the PlanAssetTypeID column.

 

[John]

I saw 4 fields with nulls and was thinking that might be the problem. I'll
see if it works.