Results 1 to 3 of 3
  1. #1
    wackywoo105 is offline Advanced Beginner
    Windows 7 64bit Access 2010 32bit
    Join Date
    Mar 2014
    Posts
    34

    Can I add a checkbox to a query that is not bound to table?

    I have some VBA code that generates a query and saves it. The query is a list of people who will be sent a communication along with the formatting for the communication. After producing the query I want to look through it and decide if there is anyone I don’t want to send the communication to. I can’t delete records from the query without deleting them from the database or I would simply do this.

    I thought I could add a checkbox in the query that I can tick to stop a communication being sent to that person. I only want the setting saved within the query and then when I have finished it be deleted along with the query.

    Is this possible?



  2. #2
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 64bit Access 2013
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,917
    The simple answer is NO. You would need to have the Checkbox bound to a table in order to save it.

  3. #3
    wackywoo105 is offline Advanced Beginner
    Windows 7 64bit Access 2010 32bit
    Join Date
    Mar 2014
    Posts
    34
    Cheers. I thought as much but was hoping there may be a work around I didn't know about.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 6
    Last Post: 01-30-2014, 05:57 PM
  2. Can a form be bound to more than one table?
    By Access_Novice in forum Forms
    Replies: 4
    Last Post: 10-24-2013, 06:23 PM
  3. Replies: 1
    Last Post: 04-26-2013, 05:30 PM
  4. Replies: 3
    Last Post: 07-24-2012, 03:11 PM
  5. Bound a unbound text box to the table
    By Brian62 in forum Forms
    Replies: 1
    Last Post: 11-06-2009, 11:05 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums