Results 1 to 2 of 2

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

  1. #1
    Join Date
    Jul 2011
    Posts
    5

    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

  2. #2
    Join Date
    Oct 2006
    Location
    Maitland NSW Australia
    Posts
    275
    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
  •