fill a form from another form (1 Viewer)

[jonwentz]

Hi all,

I have tried searching the forum for this one but cant quit find it.

So here goes

I have a form (form1) that has all kinds of data

And a form (form2) that only has 3 fields

This is what I am trying to do on form1 as the user fills it they come to the section where the address goes in. there is 3 fields for the address. I have a button there to open up form2 that contains the addresses.
Now what I would like to do is after the user finds the address that they want to input, have a cmd button that will send the current record of form2 to the 3 fields on form1.

Thanks in advance
Jon

 

[Smart]

create a button on your sub form and in the on click event type

Forms![form1]![addressfield1] = me.addressfield1
Forms![form1]![addressfield2] = me.addressfield2
Forms![form1]![addressfield3] = me.addressfield3

 

[jonwentz]

worked like a champ

thank you so very much