Code to prevent blank fields in form when exiting

[Richey]

I'm trying to tidy up a collegue's database he has written.
What I'd like is for when the user clicks onto form 2, which in turn closes form 1, it won't allow form 1 to close if there are ANY blank fields. i.e. The user must enter a number in EVERY field
I tried changing all field required properties to Yes, but it doesn't like it, so I need something that will work on a form. Maybe something on the afterupdate event of each field??
Help/code much appreciated
Richey
[sig][/sig]

 

[Robertd]

Hi Richie,

This is something that i have found difficult, seems like any traps are ok while the form has focus but all processing transfers to the next form that has focus.

a rather simplistic approach might be to make the the form modal. disable any exit's from the form until all fields have been entered. then allow the app to close the form in question and then move to the next form.

HTH
[sig]<p>Robert Dwyer<br><a href=mailto:rdwyer@orion-online.com.au>rdwyer@orion-online.com.au</a><br>[/sig]