Welcome to SPN

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

Sign Up Now!
  1.   Become a Supporter    ::   Make a Contribution   
    Target (Recurring Monthly): $200 :: Achieved: $98

Combo Box for locating records

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

  1. Kat

    Kat
    Expand Collapse
    Guest

    Hi
    I am attempting to create a combo box to locate records in a form.
    According to my instructions (and I've done it this way before), when I
    click on the Combo Box icon and into the form header area three options will
    come up and I should select the last one ("Find a record on my form based on
    the value I selected in my combo box")

    My problem is that in my equipment database (it's the only one that does
    this), when I click on the Combo Box icon in the form header area, it only
    comes up with the first two options!

    How do I create a combo box to locate my records?!!

    Thanks

    Kat
     
  2. Loading...


  3. RuralGuy

    RuralGuy
    Expand Collapse
    Guest

    On Wed, 7 Jun 2006 18:36:01 -0700, Kat <Kat@discussions.microsoft.com> wrote:

    >Hi
    >I am attempting to create a combo box to locate records in a form.
    >According to my instructions (and I've done it this way before), when I
    >click on the Combo Box icon and into the form header area three options will
    >come up and I should select the last one ("Find a record on my form based on
    >the value I selected in my combo box")
    >
    >My problem is that in my equipment database (it's the only one that does
    >this), when I click on the Combo Box icon in the form header area, it only
    >comes up with the first two options!
    >
    >How do I create a combo box to locate my records?!!
    >
    >Thanks
    >
    >Kat

    That usually means you have not bound a query/table to the form yet.
    _______________________________________________
    hth - RuralGuy (RG for short)
    Please post to the NewsGroup so all may benefit.
     
  4. Kat

    Kat
    Expand Collapse
    Guest

    What do you mean by that? How do I bind the query?
    Sorry to be so clueless.


    Kat



    "RuralGuy" wrote:

    > On Wed, 7 Jun 2006 18:36:01 -0700, Kat <Kat@discussions.microsoft.com> wrote:
    >
    > >Hi
    > >I am attempting to create a combo box to locate records in a form.
    > >According to my instructions (and I've done it this way before), when I
    > >click on the Combo Box icon and into the form header area three options will
    > >come up and I should select the last one ("Find a record on my form based on
    > >the value I selected in my combo box")
    > >
    > >My problem is that in my equipment database (it's the only one that does
    > >this), when I click on the Combo Box icon in the form header area, it only
    > >comes up with the first two options!
    > >
    > >How do I create a combo box to locate my records?!!
    > >
    > >Thanks
    > >
    > >Kat

    > That usually means you have not bound a query/table to the form yet.
    > _______________________________________________
    > hth - RuralGuy (RG for short)
    > Please post to the NewsGroup so all may benefit.
    >
     
  5. RuralGuy

    RuralGuy
    Expand Collapse
    Guest

    On Thu, 8 Jun 2006 23:23:02 -0700, Kat <Kat@discussions.microsoft.com> wrote:

    >What do you mean by that? How do I bind the query?
    >Sorry to be so clueless.
    >
    >Kat
    >
    >
    >
    >"RuralGuy" wrote:
    >
    >> On Wed, 7 Jun 2006 18:36:01 -0700, Kat <Kat@discussions.microsoft.com> wrote:
    >>
    >> >Hi
    >> >I am attempting to create a combo box to locate records in a form.
    >> >According to my instructions (and I've done it this way before), when I
    >> >click on the Combo Box icon and into the form header area three options will
    >> >come up and I should select the last one ("Find a record on my form based on
    >> >the value I selected in my combo box")
    >> >
    >> >My problem is that in my equipment database (it's the only one that does
    >> >this), when I click on the Combo Box icon in the form header area, it only
    >> >comes up with the first two options!
    >> >
    >> >How do I create a combo box to locate my records?!!
    >> >
    >> >Thanks
    >> >
    >> >Kat

    >> That usually means you have not bound a query/table to the form yet.
    >> _______________________________________________
    >> hth - RuralGuy (RG for short)
    >> Please post to the NewsGroup so all may benefit.


    You need to set the RecordSource on the Data tab of the properties sheet for the
    form.
    _______________________________________________
    hth - RuralGuy (RG for short)
    Please post to the NewsGroup so all may benefit.
     
  6. Kat

    Kat
    Expand Collapse
    Guest

    Thankyou! :)

    "RuralGuy" wrote:

    > On Thu, 8 Jun 2006 23:23:02 -0700, Kat <Kat@discussions.microsoft.com> wrote:
    >
    > >What do you mean by that? How do I bind the query?
    > >Sorry to be so clueless.
    > >
    > >Kat
    > >
    > >
    > >
    > >"RuralGuy" wrote:
    > >
    > >> On Wed, 7 Jun 2006 18:36:01 -0700, Kat <Kat@discussions.microsoft.com> wrote:
    > >>
    > >> >Hi
    > >> >I am attempting to create a combo box to locate records in a form.
    > >> >According to my instructions (and I've done it this way before), when I
    > >> >click on the Combo Box icon and into the form header area three options will
    > >> >come up and I should select the last one ("Find a record on my form based on
    > >> >the value I selected in my combo box")
    > >> >
    > >> >My problem is that in my equipment database (it's the only one that does
    > >> >this), when I click on the Combo Box icon in the form header area, it only
    > >> >comes up with the first two options!
    > >> >
    > >> >How do I create a combo box to locate my records?!!
    > >> >
    > >> >Thanks
    > >> >
    > >> >Kat
    > >> That usually means you have not bound a query/table to the form yet.
    > >> _______________________________________________
    > >> hth - RuralGuy (RG for short)
    > >> Please post to the NewsGroup so all may benefit.

    >
    > You need to set the RecordSource on the Data tab of the properties sheet for the
    > form.
    > _______________________________________________
    > hth - RuralGuy (RG for short)
    > Please post to the NewsGroup so all may benefit.
    >
     
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