Linking a form's checkbox to Yes/No Option in a table

Hi,

I am working on a database for leave application. Below is a sequence of events that is taking place in a form:

1) User Clicks on a Holiday in a Combobox. (Done)
2) A Textbox indicates whether it is available or not. (Done)
3) If it is available, a checkbox is enabled for user to select. (Done)
4) If user selects the checkbox, a message box comes, "Do you wish to Apply for Selected Leave" with Yes and No Options . (Done)
5) If user selects, "Yes", than a message box comes, "Your leave is pending for approval". (Done)

I have created a table to maintain information for leaves applied for and approved with Yes/No. Here I am facing a problem. I want the table fields to automatically get populated based on Step 4.
Even though steps 1-5 are functioning properly, this is one area where I am unable to link this function.

Kindly help me in resolving this issue as I have already wasted a lot of time in sorting this matter out.

Aman

Use an append query to append the input from your form to the table.