Hi,

I need my form to create a "Thank you for filling out this survey, have a nice day" page whenever the user completes the form and submits it. I have searched meticulously for this information in Microsoft help but to no avail. The submit button I have now adds a new record to the table. But i need the button to create a new page too. I tried giving the button more than one function but it would not allow me. Do i have to create a new button or go some other intricate route?

Thank you again for your time and help. It is very much appreciated.

Ok, you want to thank them, then open a blank form for another record?

First, I would set the Data Entry property on the form to Yes. This restricts the form to only allowing new records. Second I would create a new form and set it as Popup and Modal. The new form carries the thank you message. Use the Timer event to close the form after a set amount of time. When the form closes, they will be back tot he original form whihc should now be blank.

Hi
The attached is an example of a cmd button which closes the form and pops up the message.

Mike

hey thanks for the great info!

One thing though, I created the pop up form and set the Data entry property on the original form to yes but when I hit the submit button, the pop-up comes up but it just stays there. It doesn't close even though I set a timer on it and it doesn't start a new record.

thanks for your help!

Hi
I have modified your Form so that the Timer works as you want and then closes the form.
Look at the properties of Macro1
Regards
Mike

Hi
I have ammended your Dbase again so that when the confirmation msg closes the Form goes to a New Record
See attached - again I have modified the Macro1
Cheers

Mike

Wow, it works great. This has been a thorn in my side for the longest time. I really appreciate it. Thank you.

Hi
I have updated yet again so that on close of confirmation msg the form goes to a New Record and also
goes to the first field "First Name" on the Tabbed Form
Cheers
Mike

You are awesome. Thanks.