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

    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

    Malcolm

    Dim xDate As Date

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

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

    Me!TxtMemStatusBound.Value = Me!txtMemStatusUnbound.Value

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

  3. #3
    Join Date
    Apr 2012
    Posts
    2
    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
    Location
    Richmond, Virginia USA
    Posts
    2,763
    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 foolproof...is 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
  •