S
sg
I have a main form with a subform. The main form is called PT Test frm, the
subform is called Fail subfrm. They are linked with the field PT ID. I have
a field on the main form that is a combo box. The two choices on the combo
box are either Acceptable or Not Acceptable. When I choose Not Acceptable, I
want the subform to open so I can enter information about what was
unaccepatble. I've tried to set a condition for the field being set as Not
Acceptable and then used the Open Form action. The record is not being
saved, however, because the PT ID field is not being populated in the
subform. I've also tried adding a run command action to add a record but it
is just not doing anything when I do that.
I've attached the macro to the On Lost Focus and After Update properties of
the form, but nothing is working. If anyone out there can help me, I would
really appreciate it! Thank you in advance.
subform is called Fail subfrm. They are linked with the field PT ID. I have
a field on the main form that is a combo box. The two choices on the combo
box are either Acceptable or Not Acceptable. When I choose Not Acceptable, I
want the subform to open so I can enter information about what was
unaccepatble. I've tried to set a condition for the field being set as Not
Acceptable and then used the Open Form action. The record is not being
saved, however, because the PT ID field is not being populated in the
subform. I've also tried adding a run command action to add a record but it
is just not doing anything when I do that.
I've attached the macro to the On Lost Focus and After Update properties of
the form, but nothing is working. If anyone out there can help me, I would
really appreciate it! Thank you in advance.