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

    Dropdown in datasheet view (2000)

    Is it possible to put a drop down selecton in datasheet view so that values can be selected like they are in form view.
    see attachment for details.

    Justin.

  2. #2
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Sint Niklaas, Belgium
    Posts
    2,778
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Dropdown in datasheet view (2000)

    This is only possible if you have defined the dropdown in the table definition.
    Othewhise you have to use a continuous form instead of a form in datascheet view.
    Francois

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

    Re: Dropdown in datasheet view (2000)

    On specifiying the table as dropdown l get an error,see attachment.

    Justin.

  4. #4
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Sint Niklaas, Belgium
    Posts
    2,778
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Dropdown in datasheet view (2000)

    What are you trying ?
    I say in the table definition.
    See attachment
    Francois

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

    Re: Dropdown in datasheet view (2000)

    This has already been specified, l therefore assume what l am trying to do is not possible.

    Justin

  6. #6
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Sint Niklaas, Belgium
    Posts
    2,778
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Dropdown in datasheet view (2000)

    Did you enter the row source ?
    Francois

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

    Re: Dropdown in datasheet view (2000)

    yes, l done this.

    Justin.

  8. #8
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Sint Niklaas, Belgium
    Posts
    2,778
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Dropdown in datasheet view (2000)

    This was not the case in the sample db you send in the other thread.
    If you have done it you should have a drop down in the datasheet view.
    Francois

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

    Re: Dropdown in datasheet view (2000)

    That works fine now , thanks for our help.

    Justin.

Posting Permissions

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