Update Field by Form

[Bandara]

I 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?

 

[theDBguy]

Looks like a duplicate post of this other thread.

Update Table by Form

I have two tables. 1. CardDetails Fields: CardNo Balance 2.CardTopUp Fields : CardNo Amount I created a form using CardTopUp Table. What i Want to do is when i click submit button 1. Insert the record to Cardtopup table 2.Update only...

www.access-programmers.co.uk

 

[Gasman]

Bandara,

Please do not post duplicate posts. That only duplicates the effort for people trying to help you, as people could be offering the same advice on different threads and just wasting their time.

 

[Bandara]

Sorry