I have a form with 2 fields ([field1],[field2]), and on this form there is a button that when pressed will run an update query based off the values of these fields. BEFORE the update query executes, how can I 1st check that [field1] is not null, then check [field2] is not null? Some pseudocode of what I want
check [field1]
Is null - error message "Field 1 is null"
Is not null check [field2]
Is null - error message "Field 2 is null"
Is not null - run update query