Required field on Continuous Forms if another field is selected on close on all records
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?
Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.