Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2003
    Posts
    7

    Unanswered: Macro or Event Procedure

    In my main form I have a list of check boxes that when they check the appropriate box I want it to enter text into the subform. I have been trying to use a SetValue macro however it is just not working for me. I am not familiar with code in event procedure but I believe that this is what I want to achieve. Can I write and event procedure on click for the field for if it is equal to Yes (which is the check) then enter text I select into the form and field I select. I hope this makes sense and if anyone has any examples I would appreciate it. I am not familiar with event procedure. Thanks for your time

  2. #2
    Join Date
    Jul 2003
    Posts
    81

    Thumbs up Re: Macro or Event Procedure

    try this
    Private Sub optTest_AfterUpdate()
    If optTest = True Then
    Me.sbfrmInput.Controls("Input") = "OK"
    Else
    Me.sbfrmInput.Controls("Input") = "notOK"
    End If
    End Sub

Posting Permissions

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