I have two text boxes in my subform FormReplacementList: Replacement For and Replaced By. The subform is linked to the mainform by my primary key consisting of two fields: Form_nm and Form_vdt. Currently, the user navigates to a record using the main form and enters Replacement For information. Then, the user navigates to the Replacement For record just entered and enters the Replaced By information. I’ve been asked to automate this process if possible.
My FormsReplacement table could be populated as follows.:
Form_nm Form_vdt Replaces Replaced_By
G12453 01/87 G12453 02/88
G12453 02/88 G12453 01/87 G12501 03/89
G12501 03/89 G12453 02/88
Though the above only shows one Form replacing only one other form, it is possible for one form to replace two or more forms.
To automate this process, as I see it, I’ll need each text box to check if the entered information is the same as two of the mainform’s text boxes: txt_FormID and txt_FormVersion. But first I’ll need the info of each text box in the subform to be split in order to check against the mainform. If it is the entered info is the same, an error message should pop up. If it is not the same, it should still compare the entered info against the MasterFormsList table to determine if the item is a valid form.
I’ve thought of using a combo box for the Replacement For text box. This would ensure that at least one field would always be populated with a current form. The combo box would relate to the Replaces field in the FormsReplacement table as follows:
SELECT [tbl_Forms]![Form_nm] & " " & [tbl_Forms]![Form_vdt] AS Replacement For
FROM tbl_Forms
I’m not sure whether the update process should be done before or after update or at some other event.
If I’m missing other important trapping considerations, that would also be helpful. As always, all advice is greatly appreciated.
My FormsReplacement table could be populated as follows.:
Form_nm Form_vdt Replaces Replaced_By
G12453 01/87 G12453 02/88
G12453 02/88 G12453 01/87 G12501 03/89
G12501 03/89 G12453 02/88
Though the above only shows one Form replacing only one other form, it is possible for one form to replace two or more forms.
To automate this process, as I see it, I’ll need each text box to check if the entered information is the same as two of the mainform’s text boxes: txt_FormID and txt_FormVersion. But first I’ll need the info of each text box in the subform to be split in order to check against the mainform. If it is the entered info is the same, an error message should pop up. If it is not the same, it should still compare the entered info against the MasterFormsList table to determine if the item is a valid form.
I’ve thought of using a combo box for the Replacement For text box. This would ensure that at least one field would always be populated with a current form. The combo box would relate to the Replaces field in the FormsReplacement table as follows:
SELECT [tbl_Forms]![Form_nm] & " " & [tbl_Forms]![Form_vdt] AS Replacement For
FROM tbl_Forms
I’m not sure whether the update process should be done before or after update or at some other event.
If I’m missing other important trapping considerations, that would also be helpful. As always, all advice is greatly appreciated.
