Shawn
asked on
copy value from one subform to another
I have 2 subforms side by side with a button in the middle. Once I select a record in each subform I want to click on the button and have it copy a supplier code from one subform to the other.
Right now this is what I have under the button:
If Not IsNull([sbfrmEntitySearchC ontact].Fo rm![Suppli erIDFrance ]) Then
[sbfrmEntitySearchContact] .Form![Sup plierIDFra nce] = [sbfrmEntitySearchSupplier ].Form![Su pplierID]
End If
It doesn't seem to do anything though...when I say select I mean I just click on each record so I can see the arrow on the record selector of each subform.
Any ideas?
Right now this is what I have under the button:
If Not IsNull([sbfrmEntitySearchC
[sbfrmEntitySearchContact]
End If
It doesn't seem to do anything though...when I say select I mean I just click on each record so I can see the arrow on the record selector of each subform.
Any ideas?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
thanks gustav. got rid of the NOT and it works fine.
Me.Parent.SubformB_Subform
Note "SubformB_SubformControlNa