Recent content by 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...

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...

Sorry abt the confusion bob. 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...

Hi Bob, Maybe I should be a bit more clear on what I want to do. I want to Compare a true or false value on a form and based on this value, a record field should be incremented in another table. Could you please kindly advise me on how to do this? Thanks

Hi I would like to use a field on the form to edit a record in a table. How can I do this? Does have to be via a VB module? Ca nsomeone provide me some sample codes? Thanks