Welcome to SPN

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

Sign Up Now!

lookup columns values missing

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

  1. Jessica

    Jessica
    Expand Collapse
    Guest

    I created a look up column in a table. When I use it that data in the column
    is perfect but when I choose one, it does not display in my table the cell
    would still be blank even though I clicked on a field in my look up column.

    Thanks
    Jessica
     
  2. Ken Snell \(MVP\)

    Ken Snell \(MVP\)
    Expand Collapse
    Guest

    Not usually a good idea to create a lookup field in a table. But, you have
    done it, so....

    Can you explain more details about what you see and what is not working?
    When you say, "When I use it that data in the column is perfect", do you
    mean that you see the desired choices in the dropdown list? When you say,
    "when I choose one, it does not display in my table the cell would still be
    blank", do you mean that, after you click on your choice in the dropdown
    list, the field then shows a blank cell instead of showing the value that
    you selected?

    What is the RowSource of the lookup field? (Look at the Lookup tab when you
    have the table in design view.) Is this table a child table for another
    table? Tell us more details, please.
    --

    Ken Snell
    <MS ACCESS MVP>



    "Jessica" <Jessica@discussions.microsoft.com> wrote in message
    news:EE1CE65D-C01A-42DD-B326-6AA92EC2238A@microsoft.com...
    >I created a look up column in a table. When I use it that data in the
    >column
    > is perfect but when I choose one, it does not display in my table the
    > cell
    > would still be blank even though I clicked on a field in my look up
    > column.
    >
    > Thanks
    > Jessica
     
  3. Jessica

    Jessica
    Expand Collapse
    Guest

    I made a form from the table and I thought I should create the lookup field
    in the table instead of the form. Is it better to do this in the form?

    As far as what is happening goes...your correct. I see the desired choices
    in the dropdown list, but when I click it, instead of showing my choice it
    leaves a blank field.
    In the look up field, the row source is based on a sql query. It displays
    "client ID" from client table, and "authorization period" and "authorization
    end dates" from client authorization (subform of clients).

    I appreciate all your help and expertise as I am a novice user.

    Jessica
    "Ken Snell (MVP)" wrote:

    > Not usually a good idea to create a lookup field in a table. But, you have
    > done it, so....
    >
    > Can you explain more details about what you see and what is not working?
    > When you say, "When I use it that data in the column is perfect", do you
    > mean that you see the desired choices in the dropdown list? When you say,
    > "when I choose one, it does not display in my table the cell would still be
    > blank", do you mean that, after you click on your choice in the dropdown
    > list, the field then shows a blank cell instead of showing the value that
    > you selected?
    >
    > What is the RowSource of the lookup field? (Look at the Lookup tab when you
    > have the table in design view.) Is this table a child table for another
    > table? Tell us more details, please.
    > --
    >
    > Ken Snell
    > <MS ACCESS MVP>
    >
    >
    >
    > "Jessica" <Jessica@discussions.microsoft.com> wrote in message
    > news:EE1CE65D-C01A-42DD-B326-6AA92EC2238A@microsoft.com...
    > >I created a look up column in a table. When I use it that data in the
    > >column
    > > is perfect but when I choose one, it does not display in my table the
    > > cell
    > > would still be blank even though I clicked on a field in my look up
    > > column.
    > >
    > > Thanks
    > > Jessica

    >
    >
    >
     
  4. Ken Snell \(MVP\)

    Ken Snell \(MVP\)
    Expand Collapse
    Guest

    A "lookup" on a form would be a combo box or list box control. Better for
    you to create the "lookup" control on the form, not in the table.

    Post the SQL statement that you're using in the control as its RowSource.
    Also post the values from the Control Source, Bound Column, Column Count,
    and Column Widths properties for the "lookup" control.

    --

    Ken Snell
    <MS ACCESS MVP>


    "Jessica" <Jessica@discussions.microsoft.com> wrote in message
    news:2419BA7E-0818-4D8A-A345-D9BD7A55B602@microsoft.com...
    >I made a form from the table and I thought I should create the lookup field
    > in the table instead of the form. Is it better to do this in the form?
    >
    > As far as what is happening goes...your correct. I see the desired
    > choices
    > in the dropdown list, but when I click it, instead of showing my choice it
    > leaves a blank field.
    > In the look up field, the row source is based on a sql query. It displays
    > "client ID" from client table, and "authorization period" and
    > "authorization
    > end dates" from client authorization (subform of clients).
    >
    > I appreciate all your help and expertise as I am a novice user.
    >
    > Jessica
    > "Ken Snell (MVP)" wrote:
    >
    >> Not usually a good idea to create a lookup field in a table. But, you
    >> have
    >> done it, so....
    >>
    >> Can you explain more details about what you see and what is not working?
    >> When you say, "When I use it that data in the column is perfect", do you
    >> mean that you see the desired choices in the dropdown list? When you say,
    >> "when I choose one, it does not display in my table the cell would still
    >> be
    >> blank", do you mean that, after you click on your choice in the dropdown
    >> list, the field then shows a blank cell instead of showing the value that
    >> you selected?
    >>
    >> What is the RowSource of the lookup field? (Look at the Lookup tab when
    >> you
    >> have the table in design view.) Is this table a child table for another
    >> table? Tell us more details, please.
    >> --
    >>
    >> Ken Snell
    >> <MS ACCESS MVP>
    >>
    >>
    >>
    >> "Jessica" <Jessica@discussions.microsoft.com> wrote in message
    >> news:EE1CE65D-C01A-42DD-B326-6AA92EC2238A@microsoft.com...
    >> >I created a look up column in a table. When I use it that data in the
    >> >column
    >> > is perfect but when I choose one, it does not display in my table the
    >> > cell
    >> > would still be blank even though I clicked on a field in my look up
    >> > column.
    >> >
    >> > Thanks
    >> > Jessica

    >>
    >>
    >>
     

Share This Page