Transfer Data Between Forms

[Leerobo]

Hi

I've created a prospecting database (Access 2013) and i need to pass data from one form to another. An example would be a customer that is no longer live so i would want to move this data to another from using a button and then delete the data from the existing form once transferred.



I'm fairly new to Access, so i hope my question makes sense.

Any help would be appreciated.

[orange]

Not sure I understand what you are trying to do, but my suspicion is that you are trying to use forms where you should be using a table.

Consider, you have a table of Customers; and 1 of those Customers dies; if you want to retain an/all historic data, keep the record in the table. If you add a field to your table eg: IsActiveYN with default value empty or Y, then for the dead Customer set the field to N. Then, when you do a report, form or query, you must consider the value of IsActiveYN.
If N, then ignore that record. If you only want a report for "dead" Customers, then SELECT all records From YourTable where IsActiveYN = N.

Good luck. If I have mis-guessed, then please give more info in plain English with any details.

[Leerobo]

Hi

Thanks for your response. Having read my original post again it doesn't explain clearly what i'm trying to achieve.

Lets say the form with all the prospect data is named "Prospects" which is derived from "Prospects Table". I have another form named "Removed Prospects" which is related to "Removed Prospects Table". What i want to try and achieve is, for whatever reason, remove a prospect from "Prospects Form" and the associated table by using a button which then opens form "Removed Prospects" and in this form i am able to enter the reason for moving the prospect, this will then populate the "Removed Prospects Table".

Hope I've made myself clearer.

Thanks

[orange]

the form with all the prospect data is named "Prospects" which is derived from "Prospects Table".

I still think you are confusing the use of forms with tables.

Prospects

Select * from tblProspect where IsActiveYN = Y

RemovedProspects

Select * from tblProspect where IsActiveYN = N

You do not need 2 tables. Use the above queries as recordsource for the respective Forms.