Field Update By Form

[bandara]

was already created Form for CardTopUp by using CardTopUp Table. It has These fields.



CardNo
Amount

There is another table CardDetails It has these fields.
CardNo
Balance

In this field there is a amount .

What i want to do it when iTop up my card using CardTopUp form, when click submit button
1.Record that data to the CardTopUp table. (It's ok its working also now)
2.I want to update CardDetails Table Balance Field. Add topup amount to CardDetails balance field.
As a example in balance field abailable 1000 and i am topup 200 i want to see in carddetail table 1200

How to do?

[Bob Fitz]

This appears to be cross-posted: https://www.access-programmers.co.uk...y-form.310932/

OP, please read this link: https://www.excelguru.ca/content.php?184