G
Guest
I have a continuous form that populates based on a user selecting items on
another form's multi-select list box. They then fill in additional fields on
the continous form for the records they selected in the list box on the prior
form. I thought writing a formula that upon click of the "Save & Close this
form" button, IF there was a null value in txtComments, then msgbox "Please
enter a comment in one or more records on this continuous form." would work.
But the IF ISNULL statement only investigates the current record on the
continous form. IF(IS NULL(txtComments)...
How do I get it to determine if ANY of the comment text boxes on the
continuous form (other than the "Add New Record") are null?
another form's multi-select list box. They then fill in additional fields on
the continous form for the records they selected in the list box on the prior
form. I thought writing a formula that upon click of the "Save & Close this
form" button, IF there was a null value in txtComments, then msgbox "Please
enter a comment in one or more records on this continuous form." would work.
But the IF ISNULL statement only investigates the current record on the
continous form. IF(IS NULL(txtComments)...
How do I get it to determine if ANY of the comment text boxes on the
continuous form (other than the "Add New Record") are null?