Results 1 to 2 of 2
  1. #1
    Sla is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Aug 2014
    Posts
    5

    Setting numbers equal to words to filter forms?

    I need help! I'm not sure if it can be done or how to do it if it can be done.



    I'm working on a form that when opened has a pop up filter that asks you to enter "1, 2, 3, 4 or 5". These numbers have to be equal to an actual word within the form. For example, on the form we have a box called "business unit". One of the options in "business unit" is "Human Resources".

    I want to set 1 = to Human Resources so that way in the filter box all a person has to type is 1, and all of HR's records will pop up. The reason for this is we are trying to eliminate typing as much as possible.

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,644
    What is the cause of the popup? If it is a dynamic parameter in a query, I advise you not use that method - I NEVER do. However, if you must, try criteria under the [business unit] field:

    Choose([enter 1, 2, 3, 4, or 5], "Human Resources", "text2", "text3", "text4", "text5")
    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.

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

Similar Threads

  1. Replies: 22
    Last Post: 05-16-2014, 02:42 PM
  2. Numbers To Words
    By Derrick T. Davidson in forum Reports
    Replies: 19
    Last Post: 03-20-2013, 02:31 AM
  3. numbers to words
    By chavez_sea in forum Access
    Replies: 14
    Last Post: 01-16-2013, 07:25 PM
  4. Convert numbers to words WITH negatives
    By Alexandre Cote in forum Programming
    Replies: 2
    Last Post: 08-12-2010, 08:38 PM
  5. Set Numbers equal to each other
    By ygu3 in forum Access
    Replies: 1
    Last Post: 07-16-2009, 07:34 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