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

    Cannot get dropdown list to work (2000)

    Hi,

    I am trying to work out how l got the dropdown list to work on a list of names which l have used previously in my database.

    If you see the example of the attachment you will see what l am trying to achieve.

    Justin.

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

    Re: Cannot get dropdown list to work (2000)

    In a query, you don't really need dropdown lists, but you can create them as follows:
    - Switch to design view.
    - Click in the column you want to display a dropdown list.
    - Activate the Properties window.
    - Activate the Lookup tab.
    - Set Display Control to combo box.
    - Set Row Source Type to Table/Query.
    - Set Row Source to the name of the table or query containing the list of names.

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

    Re: Cannot get dropdown list to work (2000)

    That works great , thanks.

Posting Permissions

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