i have fields on unbound form vendor_name, vendor_number , weight, service.
i want to validate on save button whether everything is filled.
i tried to use the isnull function but i cant implement that.
finally i have used if (me.vendor_name="" or me.vendor_number="" or me.weight="" or me.service="") then and it works fine
but there is a small problem. if someone wipes the data after entering it it will still let enter save the record.
for example if someone came in weight box entered something and wiped the data before saving it will still allow the user to save the record.
can someone please tell me how to use isnull function as i have tried that for last 3 days but stuck somepoint or any other solution to solve my problem.
Regards
A learner