Required field on Continuous Forms if another field is selected on close on all records
Posted on 2009-04-14
Hi, I have a form that shows records by "Continuous Forms". One of the fields "LastChqSentNo" I require to have a error message if it is Null and another field contains the word "print".
I cant use the function required field as this field is also used in other forms were it is not required.
If I use the following code:
If Text16 = "print" And IsNull(Me.Text8) Then
iAddrQuest = MsgBox("You must enter a cheque number for each payment before you can exit", vbExclamation, "Reason for expenditure")
If I use the code above it only works on the field if it is the selected record in the form.
How can I use VBA so that if any of the records on view in the Continuous Forms are null it will give an error message if selected or not?