Entering Data on a Temporary Table

[justin]

How would I go about creating something where the user was
entering data into a Form, then, when all info is correct
the user clicks on a command button that writes the
information to the permanent table and at the same time,
deletes the information from the temporary table.

I'm trying to set something up so if the user enters data
wrong nothing will be affected until the submit button is
clicked.

Would we even need the temporary table, or could I just
set it up so no information is stored until the command
button is clicked?

THanks

-Justin

 

[Conrad]

I would (and have) designed the form to be unbound (not tied to a table).
When the user clicks a button to save the info it then writes to the table
using VBA code. Nothing is saved until they click that button. You can also
remind them before the user closes the form that they have yet to save
changes if they have not clicked the save changes button.

 

[justin]

Thanks

-----Original Message-----
I would (and have) designed the form to be unbound (not tied to a table).
When the user clicks a button to save the info it then writes to the table
using VBA code. Nothing is saved until they click that button. You can also
remind them before the user closes the form that they have yet to save
changes if they have not clicked the save changes button.



.

 

[justin]

Can I make an already existing form unbound, or do I have
to specify that when I first create the form?

What would the vba code look like for that?

thanks
-Justin

 

[Rick Brandt]

Can I make an already existing form unbound, or do I have
to specify that when I first create the form?

What would the vba code look like for that?

No code, just remove the RecordSource property of the form and the
ControlSource property of all bound controls.

 

[Rick B]

Until they page down or move to the next record, nothing will be written.
As long as they are on the form and entering information, I don't think any
other users, reports, or queries would pull that data. They can simply
ESCAPE if they decide to abort the record add, or PAGE DOWN if everything is
correct. No temporary table needed.

Rick B

 

[Guest]

Well I tried that, and it works, however, doing that
doesn't store the data entered to a table! It just gets
lost in space when you exit. So I think I'll use your
other suggestion.