TRANSFER DATA and Forms

[mp3dj]

HI All

Can anyone tell me how to transfer data from one or a number of fields in a form to other fields in the form.

FOR EXAMPLE

CUSTOMER NAME DELIVERY ADDRESS
DAVE
Evans
11112222
>>TRANSFER>>

How to transfer data form the customer fields into the delivery address, but also being able to adjust the delivery address when necessary.

Also how do you transfer a selection of data from one form onto a new/old form.

Hope you can help

Many Thanks

Dave Evans

 

[Rich]

By "tranferring" the data do you mean you want to store the same data in another table or just display it on the second form?

 

[mp3dj]

I want to store the data in another form, and maybe delete it from the current form when the transfer has taken place.

Regards

Dave

 

[mp3dj]

Thank you, I will try that and let you know.

But how do you set up the command button to transfer the data?

Regards

dave Evans

 

[mp3dj]

Ok

So do you put the

Me.txtShipAddr = Me.CustAddr
Me.txtShipZip = Me.CustZip


in the EXPRESSION BUILDER on the AfterUpdate Field.

Regards

Dave Evans

 

[mp3dj]

OK, thanks i've got that working buy updating data on the same form, but how do you make the data be transfered to a new record on a selected form.



Regards

Dave Evans