C
Cynthia
I have a field that I want to be sure is filled in before any data is saved I
used the code below. My problem is when I copy a record or records it always
gives the message box below even though the field is filled in on the item I
am copying down.
Where do I need to modify the code so this will not happen?
Private Sub Form_BeforeUpdate(Cancel As Integer)
Dim strCircNo As String
If IsNull(Me!strvoltage) Then
MsgBox "Enter Voltage"
Me!strvoltage.SetFocus
Cancel = True
End If
End Sub
used the code below. My problem is when I copy a record or records it always
gives the message box below even though the field is filled in on the item I
am copying down.
Where do I need to modify the code so this will not happen?
Private Sub Form_BeforeUpdate(Cancel As Integer)
Dim strCircNo As String
If IsNull(Me!strvoltage) Then
MsgBox "Enter Voltage"
Me!strvoltage.SetFocus
Cancel = True
End If
End Sub