Prev: Date parameters
Next: change linked sheet name
From: judyb on 24 May 2010 14:48
I have made one of my fields in a subform a combo box. When I open the form
in form view, everything looks ok, but when I open the drop-down arrow and
make a selection, an error window immediately opens. This is the 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 on a form that is open in Design view.
*The value may be too large for this field.

I can hit the Return key and move on to the next field and the selected data
stays in the field. Can anyone help in resolving this error?

Thanks in advance!
--
Judy
From: Linq Adams via AccessMonster.com on 24 May 2010 15:48
I think we need to see what code you have in the OnChange, OnClick,
AfterUpdate events of the combobox to figure out what's popping the error.
You're there and can see your code, but we're here and can't!

--
There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000/2003

Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access/201005/1

From: golfinray on 24 May 2010 16:19
Are you sure you have the master-child fields set for the subform? Is the
combo one of the fields in the subform?
--
Milton Purdy
ACCESS
State of Arkansas


"judyb" wrote:

> I have made one of my fields in a subform a combo box. When I open the form
> in form view, everything looks ok, but when I open the drop-down arrow and
> make a selection, an error window immediately opens. This is the 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 on a form that is open in Design view.
> *The value may be too large for this field.
>
> I can hit the Return key and move on to the next field and the selected data
> stays in the field. Can anyone help in resolving this error?
>
> Thanks in advance!
> --
> Judy
 | 
Pages: 1
Prev: Date parameters
Next: change linked sheet name