By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
425,705 Members | 1,845 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 425,705 IT Pros & Developers. It's quick & easy.

You can't assign a value to this object

P: n/a
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
Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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

Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.