How to change existing table record value by VBA and How to add newrecord in existing table by VBA

[K]

Hi all, I got table in my database with name "tbldata" and i have two
fields in that table with the name "Ticket_No" and "Amount". In
"Ticket_No" filed column i have value "SD001" and in same row of
"Amount" column i have figure "50". With VBA how can i lookup for
value "SD001" in "Ticket_No" field and change figure "50" to "30"
which is appearing in same row of "Amount" column field. My other
question is that how can i add new record in same table with VBA. I
want to put new value "VR004" in "Ticket_No" field column and new
figure "20" in same row of "Amount" column. I'll be very greatful if
any friend can help me with simple vba code on this.

 

[XPS35]

Hi all, I got table in my database with name "tbldata" and i have two
fields in that table with the name "Ticket_No" and "Amount". In
"Ticket_No" filed column i have value "SD001" and in same row of
"Amount" column i have figure "50". With VBA how can i lookup for
value "SD001" in "Ticket_No" field and change figure "50" to "30"
which is appearing in same row of "Amount" column field. My other
question is that how can i add new record in same table with VBA. I
want to put new value "VR004" in "Ticket_No" field column and new
figure "20" in same row of "Amount" column. I'll be very greatful if
any friend can help me with simple vba code on this.

The code for the update is:
DoCmd.RunSQL "Update tbldata SET Amount=30 WHERE Ticket_No='SD001'"

And for adding a rcord:
DoCmd.RunSQL "INSERT INTO tbldata(Ticket_No,Amount) VALUES('VR004',20)"