Results 1 to 6 of 6
  1. #1
    5 Star Lounger
    Join Date
    Mar 2004
    Posts
    924
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Dropdown not showing in datasheet view (2000)

    For some odd reason the drop down list is not showing in datasheet view yet appears fine in form view.

    Any assistance would be appreciated.

    Justin.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 28 Times in 28 Posts

    Re: Dropdown not showing in datasheet view (2000)

    In datasheet view, the dropdown arrow is only displayed in the cell that has the focus (if applicable, of course).

  3. #3
    5 Star Lounger
    Join Date
    Mar 2004
    Posts
    924
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Dropdown not showing in datasheet view (2000)

    I am not to sure what you mean by displaying the cell that has the focus?

    can you explain?

    Regards
    Justin

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 28 Times in 28 Posts

    Re: Dropdown not showing in datasheet view (2000)

    In the screenshot below, both the Customer and Employee fields are lookup fields. You only see a dropdown arrow in the Employee field for OrderID 10251, for that is the field that currently has the focus (you can see the vertical bar representing the insertion point after 'Janer Leverling'). If I click in the Customer or Employee field in another record, the dropdown arrow will be displayed there.

  5. #5
    5 Star Lounger
    Join Date
    Mar 2004
    Posts
    924
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Dropdown not showing in datasheet view (2000)

    I am still not to sure what you mean.
    This works fine with other queries but not with this query.
    Any ideas as to what l am doing wrong?

    Justin.

  6. #6
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 28 Times in 28 Posts

    Re: Dropdown not showing in datasheet view (2000)

    If you like, you can post a stripped down copy of your database. See <post#=401925>post 401925</post#> for instructions.
    Pleas indicate exactly where the problem occurs.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •