Submit Button

  • Thread starter Thread starter David Farrell via AccessMonster.com
  • Start date Start date
D

David Farrell via AccessMonster.com

After people click the submit button on my form the form closes. How do I
get Access to open the next, blank record (i.e. they submit form 3 and form 4
would then open) when they reopen the form the next time instead of going to
form 1?
 
Add a table to your database. I would put it in the Front End because it
would be user specific and faster. If you have multiple users sharing the
same front end, I would do it a little differently. I won't take time to do
the code, but here is the concept.
Create the table with two fiels: [UserID] and [LastForm]
In the Open Event of From1, Look to see what the last form opened was. If a
DLookup on [UserId] is Null, then go ahead with form1; otherwise, determine
what form should be next, open it and close form1.
The trick will be to know whether they completed the form or exited early
because of an error or because they needed to come back to it later. Once
you have made that determination, update the table so when they come back in,
the above logic will work.
I would assume you would also have to know when the user had completed all
the forms so they would start back with form1 on the next iteration.
 
Back
Top