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([sbfrmEntitySearchContact].Form![SupplierIDFrance]) Then
[sbfrmEntitySearchContact].Form![SupplierIDFrance] = [sbfrmEntitySearchSupplier].Form![SupplierID]
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.