Welcome to SPN

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

Sign Up Now!

Combo box problem

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

Tags:
  1. hbob

    hbob
    Expand Collapse
    Guest

    Why can't I pick the items from a combo box? I've lost my mind.
     
  2. Loading...


  3. Allen Browne

    Allen Browne
    Expand Collapse
    Guest

    Is the combo's Locked or Enabled property set to No?

    Is the form's AllowEdits set to No?

    Is the form bound to a non-updatable recordset?

    Is the Bound Column of the combo the wrong data type for the field it is
    bound to (i.e. its RowSource, BoundColumn, and ControlSource properties are
    inconsistent)?

    Hopefully the misplaced mind will return too. :)

    --
    Allen Browne - Microsoft MVP. Perth, Western Australia.
    Tips for Access users - http://allenbrowne.com/tips.html
    Reply to group, rather than allenbrowne at mvps dot org.

    "hbob" <hbob@discussions.microsoft.com> wrote in message
    news:F0DC22C1-E178-46A0-92FF-B4060E509DCE@microsoft.com...
    > Why can't I pick the items from a combo box? I've lost my mind.
     
  4. hbob

    hbob
    Expand Collapse
    Guest

    Sorry I was so vague in my first post. I will try to explain my problem.
    The combo box in question is in a subform. The form is set up for viewing
    only. The combo box when dropped down displays a product and it's size so
    the user can choose the correct product to view. The query has 3 fields; the
    two I mentioned and the Product ID field which is not shown in the drop down.
    I did this by setting column widths. After the product is chosen, just the
    product remains showing in the combo box and 4 other fields are populated
    with associated data from the Product ID. I'm absolutely sure that the
    properties are set correctly because I set them the exact same way as in
    another form with the same application. I have looked at every single
    property probably 9000 times now to make sure that my brain did not take a
    walk on me. The other form I mentioned works just fine. Why practically the
    same application does not work, I have no idea. I thought maybe there was
    something I was missing since this is a subform. I am relatively new to
    using Access and I was kind of thrown into creating this database from
    another database that was written a few years ago and is no longer really
    adequate for what we need. There is not really that much code involved so I
    don't think it is there. I used a subform because I put hyperlinks on the
    main form to other forms and reports. When I attempted to use my main table
    in the main form as a record source, the other forms gave me various errors
    upon opening and closing them. I don't have those errors now, but then again
    my subform doesn't work either. I did add navigation buttons on the subform
    and when I use them to view the records it works great. But I have about
    1000 records in this particular view that are alphabetically ordered. I
    really need the drop down to work for the user's benefit. I just don't get
    it....please help before I ram an icepick through my forehead. Thank you.

    "Allen Browne" wrote:

    > Is the combo's Locked or Enabled property set to No?
    >
    > Is the form's AllowEdits set to No?
    >
    > Is the form bound to a non-updatable recordset?
    >
    > Is the Bound Column of the combo the wrong data type for the field it is
    > bound to (i.e. its RowSource, BoundColumn, and ControlSource properties are
    > inconsistent)?
    >
    > Hopefully the misplaced mind will return too. :)
    >
    > --
    > Allen Browne - Microsoft MVP. Perth, Western Australia.
    > Tips for Access users - http://allenbrowne.com/tips.html
    > Reply to group, rather than allenbrowne at mvps dot org.
    >
    > "hbob" <hbob@discussions.microsoft.com> wrote in message
    > news:F0DC22C1-E178-46A0-92FF-B4060E509DCE@microsoft.com...
    > > Why can't I pick the items from a combo box? I've lost my mind.

    >
    >
    >
     
  5. Allen Browne

    Allen Browne
    Expand Collapse
    Guest

    Sometimes these things become obvious if you take a break away from the
    keyboard, for a few minutes, and come back with a fresh way of looking at
    things.

    So, the combo's RowSource is a table or query that contains 3 fields.
    Which one is the bound column?

    What is in the Control Source of the combo? Is it bound to a field, or
    unbound?

    What is the purpose of the combo: to choose a value that is stored in a
    field in a table? To filter the subform to a smaller group of records? To
    move to a particular record in the subform?

    Is the subform bound to a table or query? If a query, open the query
    directly from the Database window and see if you can update the data or not.

    How is the main form's AllowEdits property set?
    And the AllowEdits of the subform?

    --
    Allen Browne - Microsoft MVP. Perth, Western Australia.
    Tips for Access users - http://allenbrowne.com/tips.html
    Reply to group, rather than allenbrowne at mvps dot org.

    "hbob" <hbob@discussions.microsoft.com> wrote in message
    news:6C213167-5C5A-44F5-8D14-BBB2C749B3EA@microsoft.com...
    > Sorry I was so vague in my first post. I will try to explain my problem.
    > The combo box in question is in a subform. The form is set up for viewing
    > only. The combo box when dropped down displays a product and it's size so
    > the user can choose the correct product to view. The query has 3 fields;
    > the
    > two I mentioned and the Product ID field which is not shown in the drop
    > down.
    > I did this by setting column widths. After the product is chosen, just
    > the
    > product remains showing in the combo box and 4 other fields are populated
    > with associated data from the Product ID. I'm absolutely sure that the
    > properties are set correctly because I set them the exact same way as in
    > another form with the same application. I have looked at every single
    > property probably 9000 times now to make sure that my brain did not take a
    > walk on me. The other form I mentioned works just fine. Why practically
    > the
    > same application does not work, I have no idea. I thought maybe there was
    > something I was missing since this is a subform. I am relatively new to
    > using Access and I was kind of thrown into creating this database from
    > another database that was written a few years ago and is no longer really
    > adequate for what we need. There is not really that much code involved so
    > I
    > don't think it is there. I used a subform because I put hyperlinks on the
    > main form to other forms and reports. When I attempted to use my main
    > table
    > in the main form as a record source, the other forms gave me various
    > errors
    > upon opening and closing them. I don't have those errors now, but then
    > again
    > my subform doesn't work either. I did add navigation buttons on the
    > subform
    > and when I use them to view the records it works great. But I have about
    > 1000 records in this particular view that are alphabetically ordered. I
    > really need the drop down to work for the user's benefit. I just don't
    > get
    > it....please help before I ram an icepick through my forehead. Thank you.
    >
    > "Allen Browne" wrote:
    >
    >> Is the combo's Locked or Enabled property set to No?
    >>
    >> Is the form's AllowEdits set to No?
    >>
    >> Is the form bound to a non-updatable recordset?
    >>
    >> Is the Bound Column of the combo the wrong data type for the field it is
    >> bound to (i.e. its RowSource, BoundColumn, and ControlSource properties
    >> are
    >> inconsistent)?
    >>
    >> Hopefully the misplaced mind will return too. :)
    >>
    >> "hbob" <hbob@discussions.microsoft.com> wrote in message
    >> news:F0DC22C1-E178-46A0-92FF-B4060E509DCE@microsoft.com...
    >> > Why can't I pick the items from a combo box? I've lost my mind.
     
  6. hbob

    hbob
    Expand Collapse
    Guest

    Thanks for replying, I really do appreciate it. Okay, to answer your
    questions. The query has 3 fields - Product ID, Product Name, and Size. The
    bound column is 1. The control source of the combo is Product ID. The
    purpose of the combo is to let the user choose a product in order to display
    some info about the product in other text boxes that are bound to the record
    source query of the subform. The data comes from a table called Products
    that has about 15 different fields in it, but I only need to see 8 of them.
    The subform is bound to the Products table. The AllowEdits on both the main
    and subform is set to Yes. But I did have the AllowEdits set to No on the
    subform. I changed it to yes and now I get a beep when I try and click on a
    product in the drop down. All this subform does is give the user, someone
    who will not have permission to add or remove transactions or anything like
    that, the ability to view our stock level of an item and where it is located
    without having to enter any of the other forms or tables. No data is changed
    on this subform or the main form for that matter. The main form is just a
    place for hyperlinks, buttons, and my fantastic computer aided artwork. I
    hope they like stick people. I found it interesting that when the AllowEdits
    is set to No on the combo box and I try and select a product from the drop
    down that it does not beep. Turn it to yes, and there's the beep. Maybe the
    beep signifies progress. I hope so. Can I move to Australia? I can pack
    and leave right now. I won't even log off. Is your country in dire need of
    someone who tries to do things that he doesn't know how to and stays up for a
    couple of days trying to learn? I'm your guy if that is the case. Thanks
    again for your help, I look forward to your reply. I believe I will be going
    to bed shortly, so I will check it out later on today.

    Bob Non-MVP as of yet....maybe by next week

    "Allen Browne" wrote:

    > Sometimes these things become obvious if you take a break away from the
    > keyboard, for a few minutes, and come back with a fresh way of looking at
    > things.
    >
    > So, the combo's RowSource is a table or query that contains 3 fields.
    > Which one is the bound column?
    >
    > What is in the Control Source of the combo? Is it bound to a field, or
    > unbound?
    >
    > What is the purpose of the combo: to choose a value that is stored in a
    > field in a table? To filter the subform to a smaller group of records? To
    > move to a particular record in the subform?
    >
    > Is the subform bound to a table or query? If a query, open the query
    > directly from the Database window and see if you can update the data or not.
    >
    > How is the main form's AllowEdits property set?
    > And the AllowEdits of the subform?
    >
    > --
    > Allen Browne - Microsoft MVP. Perth, Western Australia.
    > Tips for Access users - http://allenbrowne.com/tips.html
    > Reply to group, rather than allenbrowne at mvps dot org.
    >
    > "hbob" <hbob@discussions.microsoft.com> wrote in message
    > news:6C213167-5C5A-44F5-8D14-BBB2C749B3EA@microsoft.com...
    > > Sorry I was so vague in my first post. I will try to explain my problem.
    > > The combo box in question is in a subform. The form is set up for viewing
    > > only. The combo box when dropped down displays a product and it's size so
    > > the user can choose the correct product to view. The query has 3 fields;
    > > the
    > > two I mentioned and the Product ID field which is not shown in the drop
    > > down.
    > > I did this by setting column widths. After the product is chosen, just
    > > the
    > > product remains showing in the combo box and 4 other fields are populated
    > > with associated data from the Product ID. I'm absolutely sure that the
    > > properties are set correctly because I set them the exact same way as in
    > > another form with the same application. I have looked at every single
    > > property probably 9000 times now to make sure that my brain did not take a
    > > walk on me. The other form I mentioned works just fine. Why practically
    > > the
    > > same application does not work, I have no idea. I thought maybe there was
    > > something I was missing since this is a subform. I am relatively new to
    > > using Access and I was kind of thrown into creating this database from
    > > another database that was written a few years ago and is no longer really
    > > adequate for what we need. There is not really that much code involved so
    > > I
    > > don't think it is there. I used a subform because I put hyperlinks on the
    > > main form to other forms and reports. When I attempted to use my main
    > > table
    > > in the main form as a record source, the other forms gave me various
    > > errors
    > > upon opening and closing them. I don't have those errors now, but then
    > > again
    > > my subform doesn't work either. I did add navigation buttons on the
    > > subform
    > > and when I use them to view the records it works great. But I have about
    > > 1000 records in this particular view that are alphabetically ordered. I
    > > really need the drop down to work for the user's benefit. I just don't
    > > get
    > > it....please help before I ram an icepick through my forehead. Thank you.
    > >
    > > "Allen Browne" wrote:
    > >
    > >> Is the combo's Locked or Enabled property set to No?
    > >>
    > >> Is the form's AllowEdits set to No?
    > >>
    > >> Is the form bound to a non-updatable recordset?
    > >>
    > >> Is the Bound Column of the combo the wrong data type for the field it is
    > >> bound to (i.e. its RowSource, BoundColumn, and ControlSource properties
    > >> are
    > >> inconsistent)?
    > >>
    > >> Hopefully the misplaced mind will return too. :)
    > >>
    > >> "hbob" <hbob@discussions.microsoft.com> wrote in message
    > >> news:F0DC22C1-E178-46A0-92FF-B4060E509DCE@microsoft.com...
    > >> > Why can't I pick the items from a combo box? I've lost my mind.

    >
    >
    >
     
  7. Allen Browne

    Allen Browne
    Expand Collapse
    Guest

    Okay, you found 1 issue, and yes, the beep indicates progress.

    You say that combo is bound to the ProductID field.
    But you also say the user is not supposed to change anything?
    Surely if they could choose a different product in the combo, they would be
    changing the value of that field in that record of the table?

    What actions have you taken to ensure the user is not able to change
    anything?

    Time to count sheep (or perhaps talk to the Shepherd.)

    --
    Allen Browne - Microsoft MVP. Perth, Western Australia.
    Tips for Access users - http://allenbrowne.com/tips.html
    Reply to group, rather than allenbrowne at mvps dot org.

    "hbob" <hbob@discussions.microsoft.com> wrote in message
    news:272D882A-B63A-45C6-9EF4-677D2D9F4F49@microsoft.com...
    > Thanks for replying, I really do appreciate it. Okay, to answer your
    > questions. The query has 3 fields - Product ID, Product Name, and Size.
    > The
    > bound column is 1. The control source of the combo is Product ID. The
    > purpose of the combo is to let the user choose a product in order to
    > display
    > some info about the product in other text boxes that are bound to the
    > record
    > source query of the subform. The data comes from a table called Products
    > that has about 15 different fields in it, but I only need to see 8 of
    > them.
    > The subform is bound to the Products table. The AllowEdits on both the
    > main
    > and subform is set to Yes. But I did have the AllowEdits set to No on the
    > subform. I changed it to yes and now I get a beep when I try and click on
    > a
    > product in the drop down. All this subform does is give the user, someone
    > who will not have permission to add or remove transactions or anything
    > like
    > that, the ability to view our stock level of an item and where it is
    > located
    > without having to enter any of the other forms or tables. No data is
    > changed
    > on this subform or the main form for that matter. The main form is just a
    > place for hyperlinks, buttons, and my fantastic computer aided artwork. I
    > hope they like stick people. I found it interesting that when the
    > AllowEdits
    > is set to No on the combo box and I try and select a product from the drop
    > down that it does not beep. Turn it to yes, and there's the beep. Maybe
    > the
    > beep signifies progress. I hope so. Can I move to Australia? I can pack
    > and leave right now. I won't even log off. Is your country in dire need
    > of
    > someone who tries to do things that he doesn't know how to and stays up
    > for a
    > couple of days trying to learn? I'm your guy if that is the case. Thanks
    > again for your help, I look forward to your reply. I believe I will be
    > going
    > to bed shortly, so I will check it out later on today.
    >
    > Bob Non-MVP as of yet....maybe by next week
    >
    > "Allen Browne" wrote:
    >
    >> Sometimes these things become obvious if you take a break away from the
    >> keyboard, for a few minutes, and come back with a fresh way of looking at
    >> things.
    >>
    >> So, the combo's RowSource is a table or query that contains 3 fields.
    >> Which one is the bound column?
    >>
    >> What is in the Control Source of the combo? Is it bound to a field, or
    >> unbound?
    >>
    >> What is the purpose of the combo: to choose a value that is stored in a
    >> field in a table? To filter the subform to a smaller group of records? To
    >> move to a particular record in the subform?
    >>
    >> Is the subform bound to a table or query? If a query, open the query
    >> directly from the Database window and see if you can update the data or
    >> not.
    >>
    >> How is the main form's AllowEdits property set?
    >> And the AllowEdits of the subform?
    >>
    >> "hbob" <hbob@discussions.microsoft.com> wrote in message
    >> news:6C213167-5C5A-44F5-8D14-BBB2C749B3EA@microsoft.com...
    >> > Sorry I was so vague in my first post. I will try to explain my
    >> > problem.
    >> > The combo box in question is in a subform. The form is set up for
    >> > viewing
    >> > only. The combo box when dropped down displays a product and it's size
    >> > so
    >> > the user can choose the correct product to view. The query has 3
    >> > fields;
    >> > the
    >> > two I mentioned and the Product ID field which is not shown in the drop
    >> > down.
    >> > I did this by setting column widths. After the product is chosen, just
    >> > the
    >> > product remains showing in the combo box and 4 other fields are
    >> > populated
    >> > with associated data from the Product ID. I'm absolutely sure that the
    >> > properties are set correctly because I set them the exact same way as
    >> > in
    >> > another form with the same application. I have looked at every single
    >> > property probably 9000 times now to make sure that my brain did not
    >> > take a
    >> > walk on me. The other form I mentioned works just fine. Why
    >> > practically
    >> > the
    >> > same application does not work, I have no idea. I thought maybe there
    >> > was
    >> > something I was missing since this is a subform. I am relatively new
    >> > to
    >> > using Access and I was kind of thrown into creating this database from
    >> > another database that was written a few years ago and is no longer
    >> > really
    >> > adequate for what we need. There is not really that much code involved
    >> > so
    >> > I
    >> > don't think it is there. I used a subform because I put hyperlinks on
    >> > the
    >> > main form to other forms and reports. When I attempted to use my main
    >> > table
    >> > in the main form as a record source, the other forms gave me various
    >> > errors
    >> > upon opening and closing them. I don't have those errors now, but then
    >> > again
    >> > my subform doesn't work either. I did add navigation buttons on the
    >> > subform
    >> > and when I use them to view the records it works great. But I have
    >> > about
    >> > 1000 records in this particular view that are alphabetically ordered.
    >> > I
    >> > really need the drop down to work for the user's benefit. I just don't
    >> > get
    >> > it....please help before I ram an icepick through my forehead. Thank
    >> > you.
    >> >
    >> > "Allen Browne" wrote:
    >> >
    >> >> Is the combo's Locked or Enabled property set to No?
    >> >>
    >> >> Is the form's AllowEdits set to No?
    >> >>
    >> >> Is the form bound to a non-updatable recordset?
    >> >>
    >> >> Is the Bound Column of the combo the wrong data type for the field it
    >> >> is
    >> >> bound to (i.e. its RowSource, BoundColumn, and ControlSource
    >> >> properties
    >> >> are
    >> >> inconsistent)?
    >> >>
    >> >> Hopefully the misplaced mind will return too. :)
    >> >>
    >> >> "hbob" <hbob@discussions.microsoft.com> wrote in message
    >> >> news:F0DC22C1-E178-46A0-92FF-B4060E509DCE@microsoft.com...
    >> >> > Why can't I pick the items from a combo box? I've lost my mind.
     

Share This Page