Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2003

    Unanswered: How do I do this simple IF statement?

    For my button I have already assigned Case statements which perform various tasks, but now I want something to happen before any of that happens.

    So I want an IF statement which does this, I'm explaining in english terms, not in coding terms:

    IF subform FRMmembers.EnoughCredit = 0 i.e. the box is not checked

    Then Display Error "Booking cannot be made. Insufficient Credit"

    Else carry on to the case statements

    How would that be done?

  2. #2
    Join Date
    Dec 2004
    Maybe something like

    If Forms!MainFormName!SubFormControlName.Form!EnoughC redit = False Then
    MsgBox "Booking Can Not Be Made"
    Exit Sub
    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