I have one command button that before you can execute the process it must have shipping information completed and then it will go on to the next step. But the message box still pops up even after the shipping info has been put in. please tell me where I went wrong in this code:
Code:
Private Sub cmdPeachtree_DblClick(Cancel As Integer)
If Not ValidateShipping() Then
MsgBoxOKOnly PleaseValidateShippingAddress
Else
Me![Status ID] = Peachtree_CustomerOrder
If IsNull(Me![Shipper ID]) = True Then
If IsNull(Me![Ship Name]) Then
Me![Ship Name] = Ship_Name
If IsNull(Me![Ship Address]) Then
Me![Ship Address] = Ship_Address
If IsNull(Me![Ship City]) Then
Me![Ship City] = Ship_City
If IsNull(Me![Ship State/Province]) Then
Me![Ship State/Province] = Ship_State_Province
If IsNull(Me![Ship ZIP/Postal Code]) Then
Me![Ship ZIP/Postal Code] = Ship_ZIP_Postal_Code
If IsNull(Me![Ship Country/Region]) Then
Me![Ship Country/Region] = Ship_Country_Region
End If
eh.TryToSaveRecord
SetFormState
End If
End If
End If
End If
End If
End If
End If
End Sub
Did i miss an "Else"? and if so if the shipping info is already in there it should just change the status per that command button.
TIA
Stephanie