Results 1 to 2 of 2
  1. #1
    4 Star Lounger
    Join Date
    Feb 2001
    Location
    Gillingham, Kent, England
    Posts
    511
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Updating a field from another field

    I have a form which has a number entry for [amount] and a tick box entry for [NotSure]. I am trying to get the number entry to automatically change to 0 when the tick box is ticked. So if someone enters something in the amount box, it is overwritten if they then tick the not sure box. I'd also like it to update onscreen, so as soon as they tick the box, the number changes in the box on the form and not just in the background.
    I've been trying to get it working with the code:

    If [NotSure] = True Then [amount] = 0
    endif

    My vba knowledge is only as much as editing old database examples to suit my own needs............help!

  2. #2
    4 Star Lounger
    Join Date
    Feb 2001
    Location
    Gillingham, Kent, England
    Posts
    511
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Updating a field from another field

    It's okay, i've found it in one of those old databases:

    If (Me.notsure) = True Then
    Me.amount = 0
    End If

Posting Permissions

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