Results 1 to 2 of 2

remove item is check box is unchecked

  1. #1
    angie is offline Competent Performer
    Windows 8 Access 2013
    Join Date
    Dec 2013
    Posts
    212

    remove item is check box is unchecked

    I have the following code that adds to a text box (proposal), it works great but would like to add that if after I check the box the item is added, if I change my mind and uncheck the box the item will be removed from the text box (proposal).

    Private Sub BlueLight_AfterUpdate()
    If Me.BlueLight = True Then
    Me.BlueLightPrice = "575"
    Else
    Me.BlueLightPrice = Null
    End If
    Me.Proposal = Me.Proposal & vbCrLf & "Install Blue Light"


    Me.Refresh
    End Sub

    thanks Angie

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    44,356
    Try:

    Me.Proposal = Replace(Me.Proposal, vbCrLf & "Install Blue Light", "")
    To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression. Attachment Manager is below Advanced editor window, click Go Advanced below Quick Reply window.

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

Similar Threads

  1. Replies: 4
    Last Post: 12-30-2015, 07:07 AM
  2. Replies: 9
    Last Post: 02-26-2013, 09:48 AM
  3. Check if item is available to hire
    By joeydeck in forum Access
    Replies: 9
    Last Post: 02-11-2013, 05:06 AM
  4. How to Check if a item has been hired
    By joeydeck in forum Access
    Replies: 8
    Last Post: 11-29-2012, 06:21 AM
  5. Replies: 2
    Last Post: 05-24-2010, 05:47 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
  •  
Tech Forums: Microsoft Office Forums