swrzzzz
10-07-2007, 04:53 PM
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
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