Re: Can't assign a value ...

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Hi Sue

Most Access error messages should have attached a caveat that says "The
suggested causes above are more than likely spurious". :-)

Some clarifying questions:

1. When you say "use" the Region field, do you mean begin to type something
in the textbox, or exit the textbox having typed something, or perhaps
something else?

2. Does the Region textbox have any event properties assigned? If so, which
one(s) and what event code is being executed?

3. Does the form have any event properties assigned, in particular, OnDirty,
BeforeInsert, OnCurrent?

4. Does this happen when there are already records in the subform, or only
when the subform is empty and you are entering the first record?

--
Cheers! :-)

Graham Mandeno [Access MVP]
Auckland, New Zealand

"Sue Compelling" <SueCompelling@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:640B5005-8603-459B-BA75-5B47CAFB8522@xxxxxxxxxxxxxxxx
Hi All

I have a subform that has 2 fields on it. Region and Address.

On the first instance only when I use the "Region" field the following
error
pops up - yet

* none of these conditions are met and
* if I press ok on the pop up it lets me enter a value regardless

Error message is ...

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

Any ideas?

TIA

Sue
--
Sue Compelling


.

Relevant Pages

  • RE: Disappearing data in sub-form
    ... Are you receiving any error messages, or do you see any status bar ... If the subform is based on a query, is the query updateable and can you ... box is likely unbound (ie. it has no Control Source specified). ...
    (microsoft.public.access.forms)
  • Re: Validation Rule on Table Field vs Form Control
    ... happens when you go from a main Form to the Form embedded in a Subform ... protect your users from unfriendly error messages, ... validation in VBA code in the AfterUpdate of Controls on the Form. ... they're trying to exit another control to get into a subform. ...
    (comp.databases.ms-access)
  • Re: Access Error Messages
    ... I have a form that has a subform in it. ... >>Private Sub FEntryDate_AfterUpdate ... >>But it doesn't seem to trigger, I keep getting the standard Access error ... >>> There's some code out there that will snoop around the error messages ...
    (microsoft.public.access.modulesdaovba)
  • Re: Spontaneous loss of subform bookmarks
    ... by bookmark you are referring to the current record of the subform (not ... its Bookmark property.) ... > The network is as stable as they get. ... > of error messages and that's just not happening. ...
    (comp.databases.ms-access)
  • Re: forms
    ... You should get in the habit of not using spaces in Object names! ... SlipDate in the above is the name property of the textbox where you enter ... > I must be particularily dense, I have tried this line of code and I keep getting error messages. ...
    (microsoft.public.access.gettingstarted)