help with parsing a form

[swrzzzz]

Hi

I am writing a quite complex form for a new VBA module. When I submit, I need to parse the contents of the form and tell the user if things are missing etc.

Can I leave the form on screen after a submit and print up an error message so I dont have to go through all the code to generate a new output of the form with the values typed so far?

I am confusing myself between the url variables, display data and database data which is different and I am thinking there must be an established pattern for this that I could follow.

I can make it work but it just looks nasty and complex.

Can anyone point me to some reading please?

Steve