From one form to another form (1 Viewer)

[kitty77]

Is it possible to copy the value from a field on form1 to a field in form2? Would like to do it in a command button if possible.

Thanks.

 

[MajP]

Yes. There are probably a few different ways.
Something like:

Forms!Form2Name.ControlOnForm2Name = Me.ControlOnForm1Name

But the natural question is what are you really doing and why copy a value from form 1 to a field on form 2? My first guess would be your tables are not probably designed.

 

[The_Doc_Man]

If it is always the same control on both forms, this is easy, as MajP shows. However, is there any variability in the To or From controls?