Filters on Forms

Posted on 2012-08-10
Last Modified: 2012-08-18
I have a form (frmProviders) that reads the record source "providers".

In that table there is a lookup to another table "states".  when creating a new record in Providers I allow a lookup to the states table ,so the user doesnt have to type in the two digit state abbr each time.  

On the form (frmproviders) i want tobe able to filter all the records to only display a certain state. When i use a combo box "and select find records on form" the value the box is displaying the two digit Code associated with the state and not the two character abbrreviation (ie.  Al).

What am I dont wrong?
Question by:seamus9909
    LVL 39

    Expert Comment

    You can create this combobox with master and in this case you will see how to set visible proper field from table. You can, of course, go to combo box properties, open Format tab and set column count to 2 and  Column width of fields to 0,1
    LVL 18

    Expert Comment

    by:Richard Daneke
    When you use a combo box to simplify data entry, you are complicating filters.

    The combo box is matching a code to bring in the state abbreviation.   Although the combo box shows the state abbreviation, the data being stored in the code used to search the 'states' table.

    As als315 referenced, this is due to the lookup table properties showing the second column of the combo box data.  Column Couont:2 and ColumnWidth:"0; 1".  
    If you set your filter combo box properties to match the data entry properties, you should be okay.

    Author Comment

    When I do as instructed and set the Column Count to 2 and the width to 0,1.  I still only see the State Code and not the abbreviation.
    LVL 39

    Expert Comment

    May be you are selecting only State code in record source query? You should have 2 columns there (Code and Name).
    LVL 39

    Accepted Solution

    Look at this sample

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Find Ransomware Secrets With All-Source Analysis

    Ransomware has become a major concern for organizations; its prevalence has grown due to past successes achieved by threat actors. While each ransomware variant is different, we’ve seen some common tactics and trends used among the authors of the malware.

    QuickBooks® has a great invoice interface that we were happy with for a while but that changed in 2001 through no fault of Intuit®. Our industry's unit names are dictated by RUS: the Rural Utilities Services division of USDA. Contracts contain un…
    I originally created this report in Crystal Reports 2008 where there is an option to underlay sections. I initially came across the problem in Access Reports where I was unable to run my border lines down through the entire page as I was using the P…
    Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
    With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…

    737 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    21 Experts available now in Live!

    Get 1:1 Help Now