M
Marianne
is this possible?
I have a Main form with a tab cntl with two subforms frmInvoiceDetail and
frmPayments.
Both Subforms are continous forms.
on frmPayments I have an unbound combo box where the user selects the
Invoice Detail Line they want to pay and that updates the [InvLineNum] and
[Pymt] fields on frmPayments.
I would also like to automatically update a checkbox on
frmInvoiceDetail[Paid] to True, and requery the combo box. Both records have
a corresponding InvLineNum.
This code in the afterupdate event of [Pymt] only works for the first line
on frmInvoiceDetail and i must manually re-type the amount in pymt to cause
the afterupdate event to fire.
Forms!frmInvoice!frmInvoiceDetail.Form!Paid = True
Any help would be appreciated. Happy Friday!
I have a Main form with a tab cntl with two subforms frmInvoiceDetail and
frmPayments.
Both Subforms are continous forms.
on frmPayments I have an unbound combo box where the user selects the
Invoice Detail Line they want to pay and that updates the [InvLineNum] and
[Pymt] fields on frmPayments.
I would also like to automatically update a checkbox on
frmInvoiceDetail[Paid] to True, and requery the combo box. Both records have
a corresponding InvLineNum.
This code in the afterupdate event of [Pymt] only works for the first line
on frmInvoiceDetail and i must manually re-type the amount in pymt to cause
the afterupdate event to fire.
Forms!frmInvoice!frmInvoiceDetail.Form!Paid = True
Any help would be appreciated. Happy Friday!