Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Unable to save data in a subForm

Discussion in 'Information Technology' started by Buddy, Oct 28, 2005.

  1. Buddy

    Buddy
    Expand Collapse
    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?
     
  2. Loading...

    Similar Threads Forum Date
    World Italy Chief Unable to Appear before Akaal Takht Breaking News Jul 23, 2011
    Controversial Unable to provide relief to ‘aam admi’ Senior bureaucrat seeks premature retirement Hard Talk Apr 14, 2010
    Sikh News Cash-starved Punjab unable to take call on octroi (Express India) Breaking News Feb 16, 2008
    Convinced By Sikh, Muslim Family Saves Hindu Lives Interfaith Dialogues Jun 24, 2016
    S Asia Sikhs want Nawaz Sharif to help save Pakistan Gurdwaras Breaking News Jan 23, 2014

  3. '69 Camaro

    '69 Camaro
    Expand Collapse
    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.


    "Buddy" wrote:

    > 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?
    >
    >
     

Share This Page