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

Cannot assign a value to this object.

P: 3
I have two comboboxes in an unbound field:
[Vendor] - finds Vendor ID, and from this list
[Application] finds Application ID using Vendor ID as the filter.

The application details are populated in a subform bound to a query "Find Application" based on a single table and the two tables are linked by Application ID.

The form is designed to enter or edit application details ie if I can't find the Application in the second combobox I add it into the subform.

My problem is that when I go to enter any details (into any field) I get an error message "You cannot assign a value to this object". The object may be: a control on a readonly form (not), on a form that is open in design view (no), too large for this field (no).

If I clear the error message, I can proceed to enter data. It seems to be due to the fact that the [Application ID] in the subform is an Autonumber. I have read other postings and enforced referential integrity etc but this has had no effect.

Does anybody have any ideas for a solution?
Oct 8 '06 #1
Share this Question
Share on Google+
1 Reply


PEB
Expert 100+
P: 1,418
PEB
When You enter the data in your combos is the keys of your form are updated?

The first thing that you should be sure is the update of the keys!

:)
Oct 8 '06 #2

Post your reply

Sign in to post your reply or Sign up for a free account.