Results 1 to 4 of 4
  1. #1
    cowboy is offline Competent Performer
    Windows XP Access 2003
    Join Date
    Jan 2010
    Posts
    291

    Getting Error: You can't assign a value to this object.

    Getting Error saying:
    Run-time error '2448':
    You can't assign a value to this object.

    I have tried:

    If IsNull(Me![Right Side DI Depth]) Then
    Me!txtZB.value = Me!txtZA.value
    End If

    If IsNull(Me![Right Side DI Depth]) Then
    Me![Left Side DI Depth] = Me!txtZA.value
    End If

    I have attached a picture with the watches I had running. I just want to test txtZB and if it is Null I want it to take the value of txtZA. txtZB has the control source of [Left Side DI Depth] and txtZA control source [Right Side DI Depth]

    Thanks for help.

  2. #2
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,521
    Where is the code? It would need to be in the format event of the section containing the control, not the open event.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  3. #3
    cowboy is offline Competent Performer
    Windows XP Access 2003
    Join Date
    Jan 2010
    Posts
    291
    Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
    ShowPage
    End Sub

    calls the function that has the code in it.

  4. #4
    cowboy is offline Competent Performer
    Windows XP Access 2003
    Join Date
    Jan 2010
    Posts
    291
    I posted the wrong picture in the first post, here are some pictures showing the actual values for the watch and a picture of the error message.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 2
    Last Post: 03-27-2010, 10:52 AM
  2. Replies: 5
    Last Post: 08-05-2009, 04:07 PM
  3. assign value from list
    By roman.pro in forum Forms
    Replies: 0
    Last Post: 05-16-2009, 04:20 PM
  4. Replies: 2
    Last Post: 03-23-2009, 05:39 AM
  5. Replies: 2
    Last Post: 02-28-2009, 03:31 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums