Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2004

    Unanswered: Visible/Invisible


    I have a main form that consists of about 3-4 subforms

    On a particular subform I need a certain field to be invisible if a combobox on that form has certain values, and to appear if it has other values.

    The values it needs to be invisible for are (asbpr, asbprp, and asbpa) It needs to be visible for values (silpr, silpa).

    I can't seem to get it to work.

    All assistance is appreciated

  2. #2
    Join Date
    Feb 2004
    use the subforms ON CURRENT event. This event gets run when records change.

    Private Sub Form_Current()
    select case cboField
    case "a", "b" , "c"
    otherField.visible = false
    case else
    otherField.visible = true
    end select
    End Sub

    You will want to use this in the cboField_AfterUpdate event as well!!

Posting Permissions

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