Results 1 to 3 of 3
  1. #1
    Join Date
    May 2005
    Posts
    126
    Provided Answers: 1

    Unanswered: Help with code in relation to Check Box 's

    Hi

    Currently using Acees 2003, I have dveloped a database to carry out customer Mi (Managment Information), working great at the moment, but at present the end user has to select using check box's, if they want to include delivery / costsavings / rebates etc.., basically if they dont check an option it is omitted from the report.

    What I would like to do now, is if the end user wants to run an Mi for say our Metal customers, by checking the Metals Mi check box, the remaining customer requirements are automatically checked, eg. delivery / costsavings / rebates

    How would I go about writing the code to do this, I am by the way a complete novice with code

    I have looked at the code bank, but with not much luck

    Thanks in advance

  2. #2
    Join Date
    Mar 2009
    Posts
    5,442
    Provided Answers: 14
    I the checkboxes are named Check_Metals_MI, Check_Delivery, Check_Costsavings and Check_Rebates, the code should look like this:
    Code:
    Private Sub Check_Metals_MI_AfterUpdate()
    
        If Me.Check_Metals_MI = True Then
            Me.Check_Delivery = True
            Me.Check_Costsavings = True
            Me.Check_Rebates = True
        End If
    
    End Sub
    Have a nice day!

  3. #3
    Join Date
    May 2005
    Posts
    126
    Provided Answers: 1
    Thanks

    Thats spot on

Posting Permissions

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