I have created a form and once the data has been validated, I insert a record into the database, then prompt the user if they would like to add another record via a msgbox, the problem I have is reinitalizing the form. Below is my code example:
BabyTot_Revised.SubmitBtn.ModalResult = MROK
myvar = Msgbox (“Do you wish to add another record?”,4 )
if myvar = 6 then
msgbox (“Clear the form and start again”)
if myvar = 7 then
BabyTot_Revised.ModalResult = MROK
I have looked at the vbscript and wanted to use the clear method however it implies it is only valid when using it with errors. Any suggestions? Thank you in advance for your continued help and support.
- You must be logged in to reply to this topic.