Store Data Temporarily

  • Thread starter Thread starter Stephen Lynch
  • Start date Start date
S

Stephen Lynch

I have a form that I do not want users to be able to post to a table unless
they complete it in its entirety.

Because the form is linked to a table that only has 1 key, if they close the
form, they can leave scraps in the table. I do not want to make each field a
required field.

What's the best solution for this, or is setting the required field the only
option?

And how do I handle error handling if they try to close?
 
Stephen

Have you looked into adding a procedure to the form's BeforeUpdate event?
You could do your validation/testing there and cancel the Close if the form
isn't completed. You could even pop up a message informing the user which
field(s) needed completion, or offering them a way to erase the partial and
leave.

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
I have a form that I do not want users to be able to post to a table unless
they complete it in its entirety.

Because the form is linked to a table that only has 1 key, if they close the
form, they can leave scraps in the table. I do not want to make each field a
required field.

What's the best solution for this, or is setting the required field the only
option?

And how do I handle error handling if they try to close?
Click to expand...

Depending on how much work you want to do ...

I use an unbound form that when the user hits a button the code does
some validation and then writes the record only if all the fields have
been filled out.

HTH,
RD
 
Back
Top