If Statement or better option

[chrisjack001]

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 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 a form called Req Log
If the BudgetCategory = 6 Open that specific record by Account in a form called Travel

Thank you very much in Advance

[pbaldy]

Here's the technique to open another form on a specific record:

BaldyWeb wherecondition

Your login would be

If Me.BudgetCategory = 6 Then
  'open one form
Else
  'Open the other
End If

[chrisjack001]

I used this code in the expression builder ON Double Click but it did not work. Can you tell me where Im suppose to put this code and this is what I type. I Im new at this.

If Me.BudgetCategory = 6 Then
Open frm.Travel
Else
Open frm.Req Log
End If

[pbaldy]

Check the link I posted for the correct syntax to open a form (you can drop the wherecondition part if you don't want it).