Welcome to SPN

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

Sign Up Now!

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.
    >
     

Share This Page