My main form is frm_EDIT_CURRENT_FULLGROWER and contained with a tab is another subform called EDIT_GROWER_TRACEABILITY_DATASHEET. They're linked via the MEMBER_ID.
My main form is frm_EDIT_CURRENT_FULLGROWER and contained with a tab is another subform called EDIT_GROWER_TRACEABILITY_DATASHEET. They're linked via the MEMBER_ID.
Can you post a screen shot in design view ? Do allow the form's name to appear in screenshot. Are you using navigation form ?
Sorry dear, I give up. We are missing something very simple here.
Either of the below seems to the reason -
-Incorrect text box control names - ( the error you mention using ME.MEMBER_ID )
-Incorrect subform control name
One last question - Are the "Main Form" and "Edit Current Grower" contained in the same form ?
No. The main for is "Edit Current Grower" (that's the form that is called up when the client selects "Edit Grower") And contained in that form, under the tab called "Traceability" is a subform called "Grower_Traceability_Datasheet" is where I am trying to compare the .oldvalue to any new value being keyed in.
CC