I am struct with following iif condition.
Here in i am applying the conditions, first if option7 = True (selected) then it has to check txtEntryNo,txtEntryType,txtEntryDate are not null if its null then it has to give following out put message mentioned in msgbox.
if all goes well then proceed with else part.
above code seams to be missing something as its either not performing anything nor giving any error.
Here in i am applying the conditions, first if option7 = True (selected) then it has to check txtEntryNo,txtEntryType,txtEntryDate are not null if its null then it has to give following out put message mentioned in msgbox.
if all goes well then proceed with else part.
Code:
If Me.Option7 = True And (Me.txtEntryDate = Null) And (Me.txtEntryType = Null) And (Me.txtEntryNo = Null) Then
MsgBox "Please Provide all required information !!!"
Else
DoCmd.OpenForm "frmJournalEntry"
DoCmd.Close acForm, Me.Name
End If
End Sub
above code seams to be missing something as its either not performing anything nor giving any error.