You can't assign a value to this object

[Jonathan]

I am getting an error message that other people have gotten. I have
done some search and reading enough to see that this error isn't only
happening to me. However, I am not able to discern a solution from
what I have read. I am still a bit new to Access. I am using Access
2000.

Here is the situation. I open up my database, go to Forms, open the
AddInvoices form, enter a Description, press enter, then try to enter
a value in the first field of the subform which is "InventoryID".
That is when I get this error message:

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

None of those apply, at least not that I could find. This has me
stumped. I have put a copy of my database online here in zip format:

http://nacnud.com/area7/dl/holyrelicstore.zip

Any help is greatly appreciated.

Thank you,
Jonathan Duncan

[dogwalker]

you don't need that field in the subform that sets the invoice id
the linking fields take care of that automatically

plus you probably should be enforcing your one-to-many relationships
you will have to clean up your data otherwise it will not allow you to
enforce them

"Jonathan" <go**********@nacnud.com> wrote in message
news:20**************************@posting.google.c om...

I am getting an error message that other people have gotten. I have
done some search and reading enough to see that this error isn't only
happening to me. However, I am not able to discern a solution from
what I have read. I am still a bit new to Access. I am using Access
2000.

Here is the situation. I open up my database, go to Forms, open the
AddInvoices form, enter a Description, press enter, then try to enter
a value in the first field of the subform which is "InventoryID".
That is when I get this error message:

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

None of those apply, at least not that I could find. This has me
stumped. I have put a copy of my database online here in zip format:

http://nacnud.com/area7/dl/holyrelicstore.zip

Any help is greatly appreciated.

Thank you,
Jonathan Duncan