Welcome to SPN

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

Sign Up Now!
  1. Guest ji, please consider donating today!
      Become a Supporter    ::   Make a Contribution   
    Monthly Recurring Target: $300 :: Achieved: $95

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
     
Since you're here... we have a small favor to ask...

More people are visiting & reading SPN than ever but far fewer are paying to sustain it. Advertising revenues across the online media have fallen fast. So you can see why we need to ask for your help. Donating to SPN's is vote for free speech, for diversity of opinions, for the right of the people to stand up to religious bigotry. Without any affiliation to any organization, this constant struggle takes a lot of hard work to sustain as we entirely depend on the contributions of our esteemed writers/readers. We do it because we believe our perspective matters – because it might well be your perspective, too... Fund our efforts and together we can keep the world informed about the real Sikh Sikhi Sikhism. If everyone who writes or reads our content, who likes it, helps us to pay for it, our future would be much more secure. Every Contribution Matters, Contribute Generously!

    Become a Supporter      ::     Make a Contribution     



Share This Page