Results 1 to 3 of 3
  1. #1
    Lounger
    Join Date
    Sep 2002
    Location
    Gainesville, Florida
    Posts
    37
    Thanks
    0
    Thanked 0 Times in 0 Posts

    combo box problem (2002/3)

    I'm trying to populate the selections of a combo box using the contents of the column it will store the selected value. In row source The statement
    SELECT DISTINCT tblContacts.club FROM tblContacts ORDER BY tblContacts.club;
    dosn't return any values to the drop down.
    combo box properties control source = club

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

    Re: combo box problem (2002/3)

    Assuming that the Row Source Type property of the combo box is set to Table/Query, Column Count is set to 1 and Column Widths is left blank, the dropdown list of the combo box should display all clubs. Of course, if there are no records in tblContacts yet, the dropdown list will be empty.

  3. #3
    Lounger
    Join Date
    Sep 2002
    Location
    Gainesville, Florida
    Posts
    37
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: combo box problem (2002/3)

    Doh! number of colums, of course, Thanks, I knew it had to be something stupid i'd done. now I can see column 1, as you said it was always there
    thanks again Hans

Posting Permissions

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