Results 1 to 3 of 3
  1. #1
    jjerome512 is offline Novice
    Windows XP Access 2007
    Join Date
    Jan 2010
    Posts
    1

    Use unbound boxes in a form

    I have a form that uses a query as it's datasource. It is pulling four fields from a table; three are checkboxes. I want to be able to use 3 unbound boxes for a user to input data. Basically what I want it to do is this:



    If checkbox 1 is True then append to three specific fields in the table.
    If checkbox 2 is True then append to the next three specific fields.
    etc.

    How do I get this to happen? Any help would be greatly appreciated!

  2. #2
    llkhoutx is offline Competent Performer
    Windows Vista Access 2007
    Join Date
    Jan 2010
    Location
    Houston, Texas USA
    Posts
    373
    What table are you takng about, your record source is a query. Most queries are non-updateable.

  3. #3
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 Access 2007
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,923
    Quote Originally Posted by llkhoutx View Post
    What table are you takng about, your record source is a query. Most queries are non-updateable.
    I do not believe this to be the case. Here's a link for reasons why a query could be read only.

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

Similar Threads

  1. Formatting control boxes in a Form
    By jbedward in forum Forms
    Replies: 1
    Last Post: 12-11-2009, 11:04 AM
  2. using a Form with combo boxes to generate reports
    By mistervelasco in forum Access
    Replies: 2
    Last Post: 10-28-2009, 03:38 AM
  3. Transfer Text to Unbound Form
    By DWS in forum Forms
    Replies: 3
    Last Post: 08-25-2009, 08:04 AM
  4. Combo boxes on a form
    By Maranna in forum Forms
    Replies: 1
    Last Post: 06-22-2009, 01:48 PM
  5. Link unbound form to bound form
    By Papote in forum Forms
    Replies: 0
    Last Post: 09-25-2008, 07:42 PM

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