Trying to get button to perform 2 functions

[dargo72]

Hello,



I have a for with a "submit" button on the bottom. When someone clicks the button I want to copy the form data to another table, and erase/delete to data from the original table, so the form is blank again.

I can do one or the other, but not both.

Help?

[RuralGuy]

Why do that? It is easy to make the Form blank without deleting the data in the RecordSource of the Form.

[dargo72]

Why do that? It is easy to make the Form blank without deleting the data in the RecordSource of the Form.

Well, I'm not sure how to do that, but I wanted to make it so someone could not see others people's entries, nor change their entry after submital.... I am open to suggestions....

[RuralGuy]

Each Form has a DataEntry property that when set True (Yes) will *only* display New records. As soon as the newly added record is saved the first time the form will no longer display that record.

[Missinglinq]

...As soon as the newly added record is saved the first time the form will no longer display that record...

Well, not exactly, Allan! After the Record is saved it will continue to be shown until that session of Access is closed, so it will be gone when anyone else opens the Form!

You had any snow up there yet? Amazingly, trees are already turning down here in Virginia, and I was cold walking the dog this morning!

Linq ;0)>

[RuralGuy]

Well, not exactly, Allan! After the Record is saved it will continue to be shown until that session of Access is closed, so it will be gone when anyone else opens the Form!
Linq ;0)>

Are you sure about the Linq? How about if the form is in single view and you move to the next record? Doesn't it basically "disappear"?

You had any snow up there yet? Amazingly, trees are already turning down here in Virginia, and I was cold walking the dog this morning!
Linq ;0)>

No snow yet but plenty of rain right now. We started seeing color about two weeks ago. It barely gets into the high 40's at night. The humming birds left about two weeks ago. Stay cool buddy.

[dargo72]

Thanks to all. I was able to get it to work as intended.

[mrojas]

If solved, please flag it as such!

[Missinglinq]

Also, forum etiquette here, as elsewhere, dictates that when you find a solution, elsewhere, you post it! In this way, others searching here, with a similar problem, can benefit from your experience, and you go from being a taker to a contributor!

Linq ;0)>