Welcome to SPN

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

Sign Up Now!

cannot make selection from a combo box

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

  1. access user

    access user
    Expand Collapse
    Guest

    I have checked the usual things like the properties - not locked, enabled etc
    etc for the combo box but it is impossible to have a selection from the drop
    down accepted.

    Any ideas welcomed.
    TIA
    James
     
  2. Loading...

    Similar Threads Forum Date
    Cannot Find A Thread ? Try "Search by Tag." Announcements Jan 21, 2013
    I cannot Keep My Hair No Longer Sikh Youth Aug 8, 2012
    India Govt cannot change purpose of acquired land: SC Breaking News Oct 6, 2011
    USA TSA: Body Scanners Cannot See Through Turbans Breaking News Jan 14, 2011
    India India cannot help but be complex Breaking News Oct 2, 2010

  3. JK

    JK
    Expand Collapse
    Guest

    Hi James,

    This is usually not a problem with the Combo Box (although a possibility
    too) but a structure of a query on which the form is based on. eg If the
    query is based on two table with a relations to a common field, the "Many"
    (ONLY) field of the "one to many" relation must be specified, if used - also
    you cannot update a Cross Tab query or a Union Query (there are more.

    Look at the query - if there is no "new Record" line (blank line or line
    with Default values only at the bottom) the query (thus the form) cannot be
    updated - make the changes in the query or create another one until you
    have the "new record" line.

    If there is a "new Record" line in the query or you don't use a query for
    your form there is still a problem in the form and/or the combo box which
    is hard to guess when one is flying on instruments.

    Regard/JK







    "access user" <accessuser@discussions.microsoft.com> wrote in message
    news:58EC0CE5-B5E8-4E13-92C1-FE90D50A100C@microsoft.com...
    >I have checked the usual things like the properties - not locked, enabled
    >etc
    > etc for the combo box but it is impossible to have a selection from the
    > drop
    > down accepted.
    >
    > Any ideas welcomed.
    > TIA
    > James
     
  4. access user

    access user
    Expand Collapse
    Guest

    Well, I think that's a good stab at it 'flying on instruments'. I was coming
    to a similar conclusion - namely, I noticed the problem occurred when I
    switched from one query as the source for the form to another one. The latter
    is more complex (linked tables) whereas the former was simply a query of all
    the records in one table.

    I'll look closer at the query along the lines you mention and report back.
    thanks
    James

    "JK" wrote:

    > Hi James,
    >
    > This is usually not a problem with the Combo Box (although a possibility
    > too) but a structure of a query on which the form is based on. eg If the
    > query is based on two table with a relations to a common field, the "Many"
    > (ONLY) field of the "one to many" relation must be specified, if used - also
    > you cannot update a Cross Tab query or a Union Query (there are more.
    >
    > Look at the query - if there is no "new Record" line (blank line or line
    > with Default values only at the bottom) the query (thus the form) cannot be
    > updated - make the changes in the query or create another one until you
    > have the "new record" line.
    >
    > If there is a "new Record" line in the query or you don't use a query for
    > your form there is still a problem in the form and/or the combo box which
    > is hard to guess when one is flying on instruments.
    >
    > Regard/JK
    >
    >
    >
    >
    >
    >
    >
    > "access user" <accessuser@discussions.microsoft.com> wrote in message
    > news:58EC0CE5-B5E8-4E13-92C1-FE90D50A100C@microsoft.com...
    > >I have checked the usual things like the properties - not locked, enabled
    > >etc
    > > etc for the combo box but it is impossible to have a selection from the
    > > drop
    > > down accepted.
    > >
    > > Any ideas welcomed.
    > > TIA
    > > James

    >
    >
    >
     

Share This Page