Before update

[Van T. Dinh]

(short answer for post-date message).

It is not possible.

--
HTH
Van T. Dinh
MVP (Access)


Before update

I put this code in Form before update:
====================================
If IsNull(Me.EmployeeName.Value) Then
Cancel = True
End If
If IsNull(Me.EmployeeSection.Value) Then
Cancel = True
End If
====================================

I have sub Form also In MY Form I can't Swithc to The SubForm Because the previous condition (The Previous Code):

What I want:
I want to Put another Condtion using chkbox in a Main Form this condition is
if chkbox.value=1 then
statments
1- let me move to MysubForm
2- Don't Save The Record In the Main Form Until I take Save Action My Self.
end If
How to convert this code to true code...

 

[1aae]

Before update

I put this code in Form before update:
====================================
If IsNull(Me.EmployeeName.Value) Then
Cancel = True
End If
If IsNull(Me.EmployeeSection.Value) Then
Cancel = True
End If
====================================

I have sub Form also In MY Form I can't Swithc to The SubForm Because the previous condition (The Previous Code):

What I want:
I want to Put another Condtion using chkbox in a Main Form this condition is
if chkbox.value=1 then
statments
1- let me move to MysubForm
2- Don't Save The Record In the Main Form Until I take Save Action My Self.
end If
How to convert this code to true code...