These 4 fields are linked to a part number, and are on a form to which needs validation.
These 4 fields have default values, but some parts do not currently have values on those fields.
When the user visits the form, and the fields are blank, and the user does not provide input for the fields, I need to assign the default value to whichever one of these 4 fields was left blank, or all if need be.
I have a simple If statement for one of the fields:
if Len(uField1) = 0 then
uField1 = "9999"
Msgbox ("part was saved successfully")
I do not want to have 4 separate if statements. If possible I would like to check all the fields using just one Nested If statement, and displaying the part saved message only once.
Would it be possible to get some help to complete this?
Thank you much.