unbound form with pre conditions on save button to save record

[tariq nawaz]

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

[pbaldy]

The test here should handle both:

http://www.baldyweb.com/BeforeUpdate.htm

[tariq nawaz]

The test here should handle both:

http://www.baldyweb.com/BeforeUpdate.htm

Bundles of thanks man.
you are a real help for me during all that time.

A warmest regard from me.

A learner

[pbaldy]

Happy to help!