Results 1 to 10 of 10
  1. #1
    ChrisN1313 is offline Novice
    Windows XP Access 2010 32bit
    Join Date
    Mar 2011
    Posts
    6

    Access 2010 Simple Yes No box


    Creating a simple question form that will have a drop down box with yes or no in it. For the life of me I cannot figure this out. Its been a while since I messed wtih access. I have searched online and tried multiiple things with no luck.

    Can anyone give me a for sure solution to just create a drop down box on a form with yes and no as options.

    Thanks
    Chris

  2. #2
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,518
    2010 still has a combo box wizard, doesn't it?
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  3. #3
    ChrisN1313 is offline Novice
    Windows XP Access 2010 32bit
    Join Date
    Mar 2011
    Posts
    6
    Quote Originally Posted by pbaldy View Post
    2010 still has a combo box wizard, doesn't it?
    It does but how do I get that info into the table?

    Under the table and field name I have the question. Then for data tpye i select yes/no. Under format I have yes/no and lookup I have combo box. For row source type I have tried all 3 options. I even created a seperate table with yes no... and tried that way with no help. Its been a really long time. I have read a few books that dealt with 07 but for the life of me still cant figure this out.

  4. #4
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,518
    Presuming the form has a record source, the wizard will ask if you want to "Store the value in this field:".
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  5. #5
    ChrisN1313 is offline Novice
    Windows XP Access 2010 32bit
    Join Date
    Mar 2011
    Posts
    6
    Quote Originally Posted by pbaldy View Post
    Presuming the form has a record source, the wizard will ask if you want to "Store the value in this field:".
    hmm let me mess around with it a bit more

  6. #6
    ChrisN1313 is offline Novice
    Windows XP Access 2010 32bit
    Join Date
    Mar 2011
    Posts
    6
    I dont think this is a wizard more of just adding a combobox. Doesnt ask anything just adds a combo box to the form.

  7. #7
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,518
    Well, the way to bind an existing combo to the table is to set its Control Source property to that field (again that assumes the form has a record source).
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  8. #8
    ChrisN1313 is offline Novice
    Windows XP Access 2010 32bit
    Join Date
    Mar 2011
    Posts
    6
    Ugh still having issues. Does anyone know where I can find an example to look at. Even if its just one question on a table, and a form. As long as it shows yes or no in a drop down box.

  9. #9
    ChrisN1313 is offline Novice
    Windows XP Access 2010 32bit
    Join Date
    Mar 2011
    Posts
    6
    Ok so just started over fresh and that helped. Created a test question and made data type as text, then display control=combo box. Row source type=value list
    Row source = "Yes";No" bound =1 column=1 and it worked.

    Thanks for the help pbaldy

  10. #10
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,518
    No problem, glad you got it sorted out.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

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

Similar Threads

  1. Opening Access 2000 file in Access 2010
    By Jacob in forum Access
    Replies: 10
    Last Post: 02-12-2011, 06:56 AM
  2. Making a leap from Access 97 to Access 2010
    By Michael Klund in forum Access
    Replies: 1
    Last Post: 12-24-2010, 04:59 PM
  3. Access 2007 to Access 2010 Problem
    By evalmedi in forum Access
    Replies: 1
    Last Post: 10-24-2010, 02:56 PM
  4. Replies: 0
    Last Post: 10-21-2010, 08:24 AM
  5. Convert access 2003 to access 2010
    By Vera in forum Access
    Replies: 3
    Last Post: 07-16-2010, 11:01 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