A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » General Discussion
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Combo Box Issue



 
 
Thread Tools Display Modes
  #1  
Old May 24th, 2010, 07:48 PM posted to microsoft.public.access
JudyB
external usenet poster
 
Posts: 46
Default Combo Box Issue

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
  #2  
Old May 24th, 2010, 08:48 PM posted to microsoft.public.access
Linq Adams via AccessMonster.com
external usenet poster
 
Posts: 1,474
Default Combo Box Issue

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/For...ccess/201005/1

  #3  
Old May 24th, 2010, 09:19 PM posted to microsoft.public.access
Golfinray
external usenet poster
 
Posts: 1,597
Default Combo Box Issue

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

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 01:14 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.