Results 1 to 3 of 3
  1. #1
    Join Date
    Aug 2010
    Posts
    2

    Unanswered: IF statement or loop ?

    I have a subform called (Recocilation Account Budget >=5) that opens up in dataview sheet. I want the user to be able to open other records in other forms specifically when he/she DOUBLE CLICKS that row in subform (Recocilation Account Budget >=5) based on the following conditions in the column field [Budgetcategory] of the subform (Recocilation Account Budget >=5)
    Some of the fields in the form are

    Account BudgetCategory Voucher

    These are the conditions:
    If the BudgetCategory = 5, 7, 8 or 9 Open that specific record by Account in another form called Req Log
    If the BudgetCategory = 6 Open that specific record by Account in another form called Travel

    Thanks for your help. Im new at this

  2. #2
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    I believe that you are in the wrong forum. This is for IBM's DB2 database product. Even if you are accessing DB2 on the back-end, it sounds like you are using some other client tool (or probably some other database).
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

  3. #3
    Join Date
    Aug 2010
    Posts
    2
    Thanks for that information

Posting Permissions

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