Hello,
I have two forms for this example named Form_A and Form_B - the users input data into Form_A using 'Insert Into' I pass some of the inputted fields into Form_B including the 'Auto_Number' field into a number field in Form_B.
I would like to in report view of 'Form_B' add a Custom Action against each record in Form_B that when clicked opens the Form_A (in edit mode) for the matching record
For sample Form_A ID field = ID_One (autonumber) is inserted into Form_B number field ID_One
On clicking the custom action I want Form_B.ID_One = Form_A.ID_one (open in edit mode)
Is this possible?