Validation rules (1 Viewer)

[Aleni]

I have a form to enter new records in a table.
But when user enter empty record i want to display a validation text to to fill the required.

I tried this code.

If txtItems="" then
msgbox("please fill the required fields")
else
code to insert the records.
end if

with this code its accepting the blank record also.
What is the correct code?
thank you...

 

[llkhoutx]

If txtItems & "" ="" then

Note that "empty" is not equal to "". Your "txtItems" is probably "empty."