Data is being deleted

[magcasen]

Hi, i need your help with my ms access form database, whenever i tried to autopopulate the textbox of my Forms with the the data i have from my Source Table then process it to save it into a Destination Table, .. the data from my Source is being Passed Onto the Destination Table,,

is there a way for me to prevent my data from being deleted after passing it to my Destination Table ?..


This is how i do it
1. Search my Source data table in order to autopopulate the textbox with data
2. Once the textbox are filled with data from my Source data table
3. An execute code will insert it into a Destination Table
4. Once the data are transferred into the Destination Table, the data from my Source Data Table are now gone ..

 

[jdraw]

Perhaps you could describe your "business" from the 30000 foot overview in plain English
so readers get the full context of your situation.