Unable to save data in a subForm

[Guest]

I am receiveing the following message when I add data to a sub form:

You can't assign a value to this object.

*The object may be a control on a read-only form.
*The object may be on aform that is open in Design view.
*The value may be too large for this field.

I don't know why the form would be a read only form or how to check for it?
The form is not in design view
It is not too large.

The control is a combo box that is a lookup value in the underlying table.
This combo box assigns values to several other text fields on the same form?

Any ideas?

 

[Guest]

Hi, Buddy.

One may receive this error message when a text string value is being
assigned to a numerical field. Let's try to narrow this down to which field
is receiving invalid input. First, is the combo box bound to a field in the
table that the rest of the form is bound to? In other words, when you see
the form in Form View, does the combo box display the name of the field it's
bound to, or does it display the word, "Unbound"?

If the combo box is unbound, then please post your VBA code and a list of
the fields that these controls are bound to, along with these fields' data
types.

If the combo box is bound, then try to isolate it by commenting out the code
that assigns values to other bound controls on the form, then save and
compile the code. Open the form in Form View again and attempt to change the
selected value in the combo box. Do you get the same error message? If so,
the bound column in the combo box should be changed to match the field that
the combo box is bound to.

The control is a combo box that is a lookup value in the underlying table.

Is this combo box an actual control on the form, or is it tied to the table
as a lookup field? Lookup fields cause all kinds of headaches, and are not
recommended.

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address so that a message will
be forwarded to me.)
- - -
If my answer has helped you, please sign in and answer yes to the question
"Did this post answer your question?" at the bottom of the message, which
adds your question and the answers to the database of answers. Remember that
questions answered the quickest are often from those who have a history of
rewarding the contributors who have taken the time to answer questions
correctly.