How to create button to Transfer from Subform to Master

[joopa]

OK,
I have a Master form with an embedded Subform. The two forms are unrelated, their tables NOT in relation.

When I navigate the Subform, I want to create a button that inserts the wanted Subform field value into one of the Master form fields.

Then when I navigate the Master form I want to see the subform change according to the same matching field values.

I have tried several ways in the expression builder, but it does not work. Any suggestions using VB?

Hope it's clear
Thanks,

 

[PHV]

Can you please explain how you can have matched fields on unrelated tables ?

Hope This Help, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884

 

[joopa]

Sure,
I tried to relate the two tabels that my Main Master table is a Many table and the One table is the subform table. Normally the Master being the One and the Sub being the many.

That won't wotk for me, so that's why I deleted the relationship.

LEt me know if I am wrong.

J

 

[PHV]

Anyway, to set a main form control value to a sub (current) form control value, try something like this:
Forms!YourMainForm!YourControl.Value = Me!ControlName.Value

Hope This Help, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244