Why is the text field trying to add an auto-number???

[coco86]

Ok, here's another strange thing Access 2000 is doing. I've had some really weird things happen since I upgraded to Windows XP professional

I have a table -- Objects

In the table I have

ObjectID (autonumber, primary key)
ObjectName (text)
ObjectType (text)

I populated the table using an append query and everything worked fine.

Now, though, when I try and go in and add a record, I'm getting (autonumber) in the ObjectID field, which is right and (autonumber) in the ObjectName field, which is very, very wrong. It won't let me type anything in the field.

What's going on here?

-Coco

 

[willir]

Coco

Definitely on the weird side of things.

Have you checked your control course for ObjectName to verify it is using the correct field?

Also, try creating a new text field and use ObjectName as the control source.

I wonder if the new way Access shows linked fields at the table level is causing some confusion.

Richard

 

[coco86]

Actually, it's doing it at the table level. There is no lookup on that field.

-Coco