Results 1 to 4 of 4
  1. #1
    Join Date
    Apr 2012

    Unanswered: Update a bound textbox from an unbound textbox error 2448

    I'm getting a error Can't assign a value to this object. I am using an unbound textbox on a form as a container for the calculations derived from the code below and then wish to update a bound textbox using the last line of the code.

    I have the form and fields set to update enabled not locked etc etc. but get this error. Any ideas what could be stopping the field from being updated would be appreciated. The form by the way is bound to a linked table.

    With Thanks


    Dim xDate As Date

    If Nz(Me.txtSubscriptionNextDue, 0) = 0 Then
    Me![txtMemStatusUnbound] = "Lapsed"
    xDate = sfrmMembershipDuesPayment.[Form]!txtSubscriptionExpires
    If xDate > Date Then
    Me![txtMemStatusUnbound].Value = "Lapsed"

    Me![txtMemStatusUnbound].Value = "Current"
    End If
    End If

    Me!TxtMemStatusBound.Value = Me!txtMemStatusUnbound.Value

  2. #2
    Join Date
    Nov 2004
    out on a limb
    Provided Answers: 59
    Instead of setting the value property try just assigning to the control.
    Me!TxtMemStatusBound = Me!txtMemStatusUnbound
    I'd rather be riding on the Tiger 800 or the Norton

  3. #3
    Join Date
    Apr 2012
    Thanks for the reply and I have tried your suggestion as a first off but still refuses to update. I only tried the .value but tried it out as the text being added is not a numerical value.

  4. #4
    Join Date
    Jun 2005
    Richmond, Virginia USA
    Provided Answers: 19
    Can you actually enter data in any Bound Control on the Form"

    Quote Originally Posted by MalGardner View Post
    The form by the way is bound to a linked table.
    What kind of 'linked table?' Do your Tables all have Primary Keys, or at least Unique Indexes, defined for them? Is the PK part of the RecordSource of the Form? If not they’ll frequently be Read-Only using ODBC.

    Linq ;0)>
    Hope this helps!

    The problem with making anything that fools are so darn ingenious!

    All posts/responses based on Access 2003/2007

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts