textbox saving details from a different form

[AlexB1]

hoping someone can help me out with a little textbox problem, iv got 2 linked forms, first form is either collecting or displaying customer details depending on conditions. and then using a button to go to a second form to deal with orders. everything is working fine apart from the address and postcode.

what im trying to do with the address is give the option to have a "address sent to" option on the order form. but by default using the address and postcode under the customer details.

so if the user doesnt select to send the order to a different address it uses the default.

the address textbox on the order form is retrieving the data from the customer form using the control source (=[Forms]![Customer INput1]![Address1]) however using this, it is not saving the address to the table.

i gather im going to need to use a macro or VBA to do this but i dont really have a clue about either

any help would be greatly appreciated,
Alex

 

[pbaldy]

You might be able to use that in the default value property of the textbox. To use code it would be:

Forms!DestinationFormName.TextboxName = Forms!SourceFormName.TextboxName

 

[AlexB1]

crackin

thanks for the fast reply

 

[pbaldy]

No problemo!

 

[AlexB1]

would it work if i did a calculation in the default value...so that i could use the control source to save the value into a table ??

 

[pbaldy]

Not sure I've tried to have a calculation in the default value; it's worth a try. The code I gave above would place a value in the text box, leaving the control source available.