Results 1 to 5 of 5
  1. 01-13-2014, 04:48 PM #1
    athyeh
    athyeh is offline Competent Performer
    Windows XP Access 2007
    Join Date
    Jun 2013
    Posts
    170

    Only accept values from the combobox.

    Hi Folks,

    I have several comboboxes setup on two different forms. Is it possible to create some type of rule that allows users to only enter/select a value that is on the combo boxes (i.e. a list box but I have already attached a bunch of queries to the combo boxes and don't want to have to rewrite them all :'()



    Thanks!
    Reply With Quote Reply With Quote
  2. 01-13-2014, 05:15 PM #2
    June7's Avatar
    June7
    June7 is online now VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,772
    Don't understand. Where else would they enter/select value?
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
    Reply With Quote Reply With Quote
  3. 01-13-2014, 05:30 PM #3
    pbaldy's Avatar
    pbaldy
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,652
    Have you tried setting the Limit to List property of the combo to Yes?
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com
    Reply With Quote Reply With Quote
  4. 01-13-2014, 05:33 PM #4
    athyeh
    athyeh is offline Competent Performer
    Windows XP Access 2007
    Join Date
    Jun 2013
    Posts
    170
    Quote Originally Posted by pbaldy View Post
    Have you tried setting the Limit to List property of the combo to Yes?
    Thank you.
    Reply With Quote Reply With Quote
  5. 01-13-2014, 05:34 PM #5
    pbaldy's Avatar
    pbaldy
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,652
    No problemo.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com
    Reply With Quote Reply With Quote
Please reply to this thread with any new information or opinions.
« Previous Thread | Next Thread »

Similar Threads

  1. Combobox setting other combobox values problem
    By maxmaggot in forum Programming
    Replies: 8
    Last Post: 06-30-2013, 07:18 AM
  2. 1 Combobox with values from 2 tables
    By Comsoft in forum Access
    Replies: 1
    Last Post: 04-23-2013, 05:42 PM
  3. ComboBox not listing values
    By tylerg11 in forum Access
    Replies: 1
    Last Post: 09-23-2011, 10:28 AM
  4. Values in a combobox
    By kbp in forum Access
    Replies: 2
    Last Post: 02-01-2011, 03:53 AM
  5. Calculating values based on Combobox value
    By BrianFawcett in forum Programming
    Replies: 1
    Last Post: 05-06-2010, 01:26 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
  •  

Forum Rules

Other Forums: Microsoft Office Forums