RCMB,
Your code works great! On minor issue (I am sure that solve it once I have a good look at it, but I wanted to keep the dialog going because I am learning an incredible amount from this) I get a no records returned message, even though the table update works perfectly.
I noticed that the last submit if the user wants to register for the class (nice touch) submits the inf to page 3 - which I
Can code to forward to the final page so this is no big deal. The question is more from curiosity. Why does page 3, if not allowed to redirect, still give a no records returned message.
I am continuing this if you are interested at all in tweeking this process a little more. If not I am very gratefull, and what I have is more than enough.
~David
To correct this problem simply open page 3.
You will see the start of the DBRW -- double click on the start region and it will open the wizard.
Proceed to the step 3 and click on More Options...
In this window you will see the message No records Returned
Simply delete this message or modify to display a message of your choice like :
-- Your registration was successfully recorded --
Then finish the wizard. Note: If you leave the field blank it will work just fine and not display anything on the screen, but if you run the DBRW again FrontPage will automatically put the No Records Returned message back in the box so you will have to delete it to keep the message from displaying. Quite annoying trait in FrontPage :-(.
If you decide to put you own personal message in the box then remove the reidrect and create a hyperlink back to page of your choice. I tend to leave the message blank and have my page redirect but the down side to this is if there is an error the user never knows it and assumes their information was recorded and it was not. Much like what we were seeing when we first started this project.
R/Curtis