The way that it's supposed to work is this:
You modify the form:
Then in Modifier you set the Required property to True
Be sure when you're testing to 'Set Security' to your modified form.
Anyway, when we did this it did not make the field required. 10 points to anyone that knows why.
In order to get this working, we had to do a VBA mod.
Add the Vendor form to visual basic as shown, and then add the Save button to VB as shown in this article.
Now we want to do the same basic thing to the Vendor options form. Add the form to Visual Basic, then add Fields to Visual Basic. We'll only need to add the Payment Terms field
Open the Visual Basic editor (Alt + F11, or it's on the menu above) and then enter the code below in the Vendor form
Private Sub Save_BeforeUserChanged(KeepFocus As Boolean, CancelLogic As Boolean)
If VendorMaintenanceOptions.PaymentTerms = "" Then
MsgBox ("Please enter payment terms")
CancelLogic = True
End If
End Sub
Private Sub Window_BeforeModalDialog(ByVal DlgType As DialogType, PromptString As String, Control1String As String, Control2String As String, Control3String As String, Answer As DialogCtrl)
If PromptString = "Do you want to save changes?" Then
If VendorMaintenanceOptions.PaymentTerms = "" Then
MsgBox ("Please enter payment terms")
Answer = dcButton3
End If
End If
End Sub
The code works like this:
First we trap the save button. If the Payment Terms field is empty we cancel the save.
But there is a complication, the user can choose to navigate away from the Vendor using the 'VCR' buttons at the bottom of the form. If that happens, they get a modal dialog that asks if they want to save the record. We trap that dialog too, and basically run the same logic; we cancel the save if the Payment Terms are blank.
Comments? Questions?