D
Dan
I am designing a Accounts receivable form and I have it
so that when the user clicks a button it gets the value
of the selected record from the subform and then opens a
new form (bill) and inserts the values. This is the code
that I have to insert the values:
Forms("Bill Form")![Previous Payments] = [Forms]!
[Accounts Receivable]![AR Payment Schedule subform].
[Form]![Amount Paid]
This works fine but I need to be able to get the value of
the previous payment which is located in the previous
record. It takes the values of the selected record by
default but I need to know how to get the previous record.
so that when the user clicks a button it gets the value
of the selected record from the subform and then opens a
new form (bill) and inserts the values. This is the code
that I have to insert the values:
Forms("Bill Form")![Previous Payments] = [Forms]!
[Accounts Receivable]![AR Payment Schedule subform].
[Form]![Amount Paid]
This works fine but I need to be able to get the value of
the previous payment which is located in the previous
record. It takes the values of the selected record by
default but I need to know how to get the previous record.