Hi. I'm trying to open a form based on a DLookup value from a query. The results from the DLlookup will be either a 1 or 0. I would like to open the form only if the DLookup = 1
I'm struck on the where condition.
Private Sub OpenUnbilled_Click()
Dim tmp As String
tmp = DLookUp("IsUnbilled", "q_StartEndDate", "IdMatter=" & Forms!f_Start_End_Date!cbo_Matter)
DoCmd.OpenForm FormName:="f_StartEndDate_Unbilled"
WhereCondition:=
End Sub
I'm struck on the where condition.
Private Sub OpenUnbilled_Click()
Dim tmp As String
tmp = DLookUp("IsUnbilled", "q_StartEndDate", "IdMatter=" & Forms!f_Start_End_Date!cbo_Matter)
DoCmd.OpenForm FormName:="f_StartEndDate_Unbilled"
WhereCondition:=
End Sub