Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Limited Combo Box Option

Discussion in 'Information Technology' started by Kevin, Jul 28, 2006.

  1. Kevin

    Kevin
    Expand Collapse
    Guest

    I want to add a combo box to a prieviously built form, to allow the user to
    choose a customer record, rather than having to scroll down through the
    records to find it. When I go to add the combo box, though, the radio button
    for "Find a record on my form based..." does not appear. When I create a
    combo box on a new form, in the same DB, based on the same query, it is
    available. Any ideas about why this could be, and how to make this option
    available in this form?

    thanks
     
  2. Loading...

    Similar Threads Forum Date
    What actually are the 3 worlds? And is Maya limited only to the physical plane? Questions and Answers Nov 30, 2012
    Sikh News Mightier than the kirpan | Hardeep Singh Kohli (Guardian Unlimited) Breaking News Feb 10, 2010
    Sikh News Sikh officer wins payout in turban row (Guardian Unlimited) Breaking News Oct 7, 2009
    Sikhism Sikhs Unlimited Book Reviews & Editorials Jul 9, 2009
    Sikh News Sikh police seek bulletproof turbans (Guardian Unlimited) Breaking News May 12, 2009

  3. Tom Wickerath

    Tom Wickerath
    Expand Collapse
    Guest

    Hi Kevin,

    The form that you are having trouble with is based on a SQL statement,
    instead of a saved query. Open the form in design view. Click on View >
    Properties, if required, to display the properties dialog. Click on the small
    black square in the upper left corner to select the form. You should see the
    word "Form" in the blue title bar of the properties dialog. Click on the Data
    tab. The first entry is for Recordsource. I'm fairly certain that your
    recordsource starts with a SELECT statement, instead of being a saved table
    or query. Click on the build button to open the query builder. Save the
    result as a new query, by clicking of File > Save. Then close the query
    builder. You should now have the third option available.

    Combo box to find a record
    http://www.access.qbuilt.com/html/find_a_record.html


    Tom Wickerath, Microsoft Access MVP

    http://www.access.qbuilt.com/html/expert_contributors.html
    http://www.access.qbuilt.com/html/search.html
    __________________________________________


    "Kevin" wrote:

    > I want to add a combo box to a prieviously built form, to allow the user to
    > choose a customer record, rather than having to scroll down through the
    > records to find it. When I go to add the combo box, though, the radio button
    > for "Find a record on my form based..." does not appear. When I create a
    > combo box on a new form, in the same DB, based on the same query, it is
    > available. Any ideas about why this could be, and how to make this option
    > available in this form?
    >
    > thanks
     

Share This Page