Question How to edit records via forms?

[pierreiza]

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

 

[boblarson]

You don't need code to do this. Just build a form using the form wizard and you will have what you need. The key is that the field is bound to the control. It would appear that you could get some benefit of working through these tutorials:

http://www.functionx.com/access2003/index.htm

 

[pierreiza]

You don't need code to do this. Just build a form using the form wizard and you will have what you need. The key is that the field is bound to the control. It would appear that you could get some benefit of working through these tutorials:

http://www.functionx.com/access2003/index.htm

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

 

[boblarson]

You should always be as specific as possible when asking questions. That way we save time and effort.

So, can you give me a direct example so that I can give you the best method for doing this (if it isn't something that should be done some other way).

 

[pierreiza]

You should always be as specific as possible when asking questions. That way we save time and effort.

So, can you give me a direct example so that I can give you the best method for doing this (if it isn't something that should be done some other way).

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

Thanks in advance for your advise