Results 1 to 4 of 4
  1. #1
    4 Star Lounger
    Join Date
    Feb 2002
    Posts
    537
    Thanks
    0
    Thanked 0 Times in 0 Posts

    After update in form (Access 2000)

    In my form I have to update manually the exworks prices.I want to build an afterupdate event setting the yesNo field obsolete to true and in this way the updated product will disappear from the list, but somehow I cannot give the command. Can you help me ?
    Attached Files Attached Files

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: After update in form (Access 2000)

    You can set Obsolete to True in the After Update event of the exworks text box, then requery the form in the After Update event of the form itself, so that the obsolete record isn't displayed any more:

    Private Sub exworks_AfterUpdate()
    Me.Obsolete = True
    End Sub

    Private Sub Form_AfterUpdate()
    Me.Requery
    End Sub

  3. #3
    4 Star Lounger
    Join Date
    Feb 2002
    Posts
    537
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: After update in form (Access 2000)

    Thank you very much !! It works great !!
    When i change the exworks price and then click Enter,i go to the field Obsolete.The exworks tab index is 4 and the obsolete is 5.How could i make the cursor go to the next exworks price. or at least to the next row ?

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: After update in form (Access 2000)

    If you set theTabstop property of the exworks text box to no, you will skip over it when you press Tab or Enter, and since exworks is the last control, you'll move to the next record.

Posting Permissions

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