Opening Forms Multiple Arguements

[Lupson2011]

Hi



Having a Friday brain moment.

Am trying to open a form to display specific information, in this case, by Year End and by Organisation. So I want to show the year end figures for that organisation. I have tried one arguement, but now realise I need both arguements, which I assume is Year End and Organisation.

The two fields I am working with are YearEnd and Trust1..dont suppose someone is not having a brain moment and let me know the line of code to put underneath the button?

THanks

Lupson2011

[maximus]

Simple code to demonstrate how to open a form with multiple criteria to display records.

here is a simple code where I use employee_Name(e_name) and Date of birth(b_date) as criteria to open employee form (Table6).

Private Sub Command9_Click()
Dim strCriteria As String
Dim strDocname As String

strDocname = "Table6"

If IsNull(Me.Text10) Then
    If Not IsNull(Me.Text12) Then
            strCriteria = "e_name='" & Me.Text12 & "'"
    End If
End If
If IsNull(Me.Text12) Then
    If Not IsNull(Me.Text10) Then
        strCriteria = "b_date=#" & Me.Text10 & "#"
    End If
End If
If Not IsNull(Me.Text10) Then
    If Not IsNull(Me.Text12) Then
        strCriteria = "b_date=#" & Me.Text10 & "# And e_name='" & Me.Text12 & "'"
    End If
End If


If Len(strCriteria) > 0 Then
    DoCmd.OpenForm strDocname, , , strCriteria
Else
    MsgBox "Select a criteria"
End If
    
End Sub