TRANSFER FIELD DATA to A NEW FORM

[mp3dj]

Hi All

I was wondering if anyone could tell me how to transfer data from one in field on TABLE 1 and TRANSFER it to a field on TABLE 2.
And then delete the record on TABLE 1.

I have worked out how to TRANSFER data from one field to another, but this only works in the same form.

Hope You can help.

Regards

Dave Evans

 

[bradcccs]

Do you wish to transfer the entire record from TableA to TableB, or just one field from a record in TableA to TableB?

 

[mp3dj]

I would like to have the opportunity to transfer all the selected record and also just one or more fields.

Regards

Dave Evans

 

[bradcccs]

To transfer a Record from one table to another, look up use of "Append Query" and "Delete Query" (Action Queries).

You can construct both of these using the Query design grid if you are not familiar with SQL.

Overview:

Use Append query to Add require record to second table
Then remove record from original table using delete query

You will have to be aware of data types etc within each table, and ensure that all table requirements are met.

Brad.