Question How to edit records in tables based on input from Forms

[pierreiza]

I would like to create an instalment management database. Basically I have a table, instalment details, which tracks the number of instalments paid and to be paid. The instalment details table has a Loan ID which is unique to each instalment. I have a daily accounts table which keeps track of all the payments on a daily basis.

There are cases whereby it just some form of paymenr. Hence this is not updated into the instalment table.

I have created forms for the daily accounts table and there is yes/no field named instalment. If it is yes for instalment field, I want it to updated into the instalment details table by incrementing the number of instalments paid and decreasing the instalments to be paid.

 

[dreamdelerium]

maybe create a sub procedure for the onclick event of the button sending the sql statement. when the procedure is called, check the value of the combobox. if yes, do the sql statement, if no do something else

 

[neileg]

A better solution is to hold the total number of instalments due in a table and when you need to know the amount outstanding, count the number paid and subtract this from the total. Storing the number of outstanding installments is a bad way of dealing with this.

 

[pierreiza]

Expression error

Hi neileg,

Thanks a lot.

I have taken your suggestion. But I have a problem with counting the number of instalments paid. In the form which present the payments for a particular Loan ID, I inserted a text box and the control source = Count([instalment=Yes]) but this expression gave me an error. Could you kindly advise on what could be the problem

 

[neileg]

Use DCount(). Check Access help on this and post back if you have problems.