List box error: "You Can't Assign a Value to This Object"

[Timberwolf]

I have a form called Contacts and inside that a subform called PubOrders and inside that a subform called Publications (which contains a list box that looks up our pubs in another table). When I'm in the list box field, the drop-down list works fine, but after I make the selection, I get an error message:

iMicrosoft Access
You can't assign a value to this object.
* The objct may be a control on a read-only form.
* The object may be on a form that is open in Design view.
* The value may be too large for this field.

I know all of my relationships are okay, because previously sold publications are showing up fine under their respective Contacts. (For reasons that I won't detail here, I had to update the tables and recreate relationships between Contacts/PubOrders/Publications/ListOfPubs.)

 

[Chris@CpDataCompany]

I cant get a good picture of your form/sf list box but try this.

If it displays ok but you just cant select anything, what you are trying to select isnt clear to Access. That's your bound column.
Look at the query(or sql )of the row source,
to make sure that your bound column is referencing the query column you want.

Chris
CP Data Company
cpdatacompany@hotmail.com

 

[Timberwolf]

It is referencing the correct column. As a matter of fact, it allows me to change existing records by using the drop-down list. It just won't let me add a new record! Ack.

Any more ideas? (Thanks, by the way!)

 

[charityg]

I had a similar problem yesterday. Maybe your issue is something similar.

My subform's datasource table (one-to-one with the main form) had an autonumber datatype for the ID field that linked it to the main form. I changed it to number and the error went away.

Anyway, hope this helps

 

[Timberwolf]

OH, YES! I think that helped. Thanks. Now ... on to the NEXT problem!