form to form value

[kitty77]

I have a form (main) that has a command button that opens (bulk) another form (specific record) based on field [IDnumber].
How can I double click on a field on the bulk form and have it populate a field with that value on the main form?

I can make it work if it's on the same form but not to another form.

Main Form[Msamplenumber1] = Bulk Form[Bsampleid1]

 

[theDBguy]

Have you tried?

Forms!MainFormName.Msamplenumber1 = Me.Bsampleid1

 

[The_Doc_Man]

The syntax you use to move data from one form to another depends on which form is doing the moving. If the forms are parent/child (in the sense that the child form is a subform) then there is one syntax to use. If the forms are co-equal there is another syntax to use. Which relationship applies here?

 

[kitty77]

Have you tried?

Forms!MainFormName.Msamplenumber1 = Me.Bsampleid1

Perfect!!!

 

[theDBguy]

Perfect!!!

Glad we could assist. Good luck!