Jun 15 2006, 12:52 PM
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.
Jun 15 2006, 01:00 PM
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.
Jun 15 2006, 01:03 PM
The attached is an example of a cmd button which closes the form and pops up the message.
Jun 15 2006, 11:02 PM
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.
Jun 15 2006, 11:10 PM
thanks for your help!
Jun 20 2006, 11:10 AM
I have modified your Form so that the Timer works as you want and then closes the form.
Look at the properties of Macro1
Jun 20 2006, 12:43 PM
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
Jun 20 2006, 01:02 PM
Wow, it works great. This has been a thorn in my side for the longest time. I really appreciate it.
Jun 22 2006, 09:32 AM
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
Jun 27 2006, 10:41 AM
You are awesome. Thanks.
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here