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

 

[Hayley Baxter]

Use an Append Query to take the data from table1 to table2 then a delete query to delete the data from table1.

 

[bradcccs]

Please don't post the same question in multiple forums!

You end up wasting the valuable time of experts like Hayley.

 

[Hayley Baxter]

not sure about the expert part Brad, that's more like your "tag" but thanks for the compliment anyway

 

[bradcccs]

Ok, perhaps we can both use the term (very loosely)