How to code reset button to change booked seats to available seats in VB

See more:

VB

MS-Access

Hello. I'm currently preparing a seating system in VB. May i know how can I change the booked seats into available by clicking "Reset" button? My database consists of "Booking" table that comprises the booking details and "Seating" table that comprises details including "Availability" whereby once the seats are booked, it will change the seats from available to booked under "Availability" column.

As per my understanding, when i click the "Reset" button, it will delete the records in "Booking" table and update "Seating" table from booked to Available under "Availability" column. This action would lead my booked seats turn to available seats.

I'm looking for help for this issue. Thank you in advance!

What I have tried:

I wish that I post my seating screen to show my progress but I'm unsure of attaching image here.