As is usual in Access / VBA there are lots of ways of removing the fur from a feline....
One way is to place some code in each relevant controls' before update event. This code populates a a message box prompting user action.
Another option is to place the validation in the forms on update event, rolling up all the messages that would be generated in the individuals controls before update event.
Personally I prefer the latter: the reason a single message to the user, less confusion, less need to read the screen.
I've also found a good solution to such user interface issues is to trip the required / error controls by setting their background colour, or some other appropriate means of guiding users to problems. You can also set those controls mouseover / tooltip to indicate what the error is.
just my 2 1/2d
Last edited by healdem; 11-16-05 at 16:35.
Reason: correcting spelling / aka not typing when pished