Still learning myself but in your 2nd problem try:
<CODE>
If nz(Me.Text6,"") = "" Then
Msgbox code
Elseif nz(Me.Text10,"") = "" Then
Msgbox code
Else
Code as you had it...
End If
</CODE>
Normally you would just say Null,
rather than "Null", which is a string.
Sent from my iPhone using Tapatalk