I'm using this code to check the user is entering some costs before creating an invoice:
It works I'm just trying to improve this before I let people on it. Sometimes i get the message box "Enter at least 1 line value." even when lines are entered.Code:If IsNull(Me.Invoice_Generator2.Form.Inv_Quantity) = True Then MsgBox "Enter at least 1 line value."
I'm guessing because one line is null it triggers the event. ( but this is not all the time.)
Is there a better way to get the results I want?
Andy.