-
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.
Allan
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|