Question Auto Close form after update

[josephbupe]

Hi,

I have a form with three field:

CaseName, CaseDate, CaseStatus

All I need is a small code that would display message and close the form automatically after user enters data in all the three. All fields should be mandatory.

Thanx.

Joseph

 

[JamesMcS]

Try this in the afterupdate of the last text box:

if casename<>"" and casedate<>"" and casestatus<>"" then
me.form.close
else
msgbox "fill in all the boxes"
endif

I think that's the right syntax anyway