468,321 Members | 1,711 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,321 developers. It's quick & easy.

Cannot assign a value to this object.

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
1 2764
1,418 Expert 1GB
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.

Similar topics

10 posts views Thread by Doug Jordan | last post: by
4 posts views Thread by Eric | last post: by
8 posts views Thread by Sergei | last post: by
2 posts views Thread by Jim McGivney | last post: by
1 post views Thread by No_Spam | last post: by
6 posts views Thread by Håkan Johansson | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.