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

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).

Thanks for that information