I have a bit of code that uses controls on a form to batch add records to the tables. Before the code executes, it needs to do a check to make sure that all of the needed data has been supplied. I've set something up that works, but I wonder if there might be a more preferable way to do it or if this looks good, thoughts?
Thanks!
Thanks!
Code:
If IsNull(txtDateAdded) Then
MsgBox "Please supply the date that the Label record was created"
Exit Sub
Else
If IsNull(cboRecordCreator) Then
MsgBox "Please supply the name of the person creating the records"
Exit Sub
Else
If IsNull(cboRecordRequester) Then
MsgBox "Please supply the name of the person who authorized / requested the record creation."
Exit Sub
Else
If IsNull(txtNotes) Then
MsgBox "Please supply a note regarding the creationg of these records"
Exit Sub
Else
If MsgBox("Are you sure you want to upload " & Me.List2.ItemsSelected.Count & " Records?", vbYesNo) = vbYes Then
'''''code irrelevent to my question goes here'''''
MsgBox ("Upload Complete. Please verify your records.")
Else
MsgBox ("Upload Canceled")
End If
End If
End If
End If
End If