Controls

Re: Action to run the new record function after submit

blackduke77 — Thu, 07 Dec 2006 22:21:32 GMT

Thanks, I am using SQL 2005 and I have complete access to the server and database. I think I understand what is happening, when we run the the query, I think it pulls the records into the form and works with them only, so if you change the data that it has pulled back it will update the data with the amended data and not insert new rows. It makes sence in my head!!!

Have you got any clues to get round this?

Re: Action to run the new record function after submit

Patrick Halstead — Thu, 07 Dec 2006 19:12:52 GMT

Hi BlackDuke77 and welcome to our forum!
Sounds like you are submitting to a database. Is that correct? What kind of database is it? SQL or Access? Do you have the ability to administer the database?

Action to run the new record function after submit

blackduke77 — Thu, 07 Dec 2006 17:23:31 GMT

I have a form, which 1 user will fill out many time with different values, so the form will not close between submits, currently unless the new record is pressed inbetween these submits it over rights the data previously submitted.
So I need a to set the form to automatically run the new record function after a sucsuful submit.
How can this be acheived? it would be handy if I did not need any code or very simple code !!!!

Thanks