Results 1 to 3 of 3
  1. #1
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    Display an unbound value in a bound combo! (Access 2000 >)

    Hi,
    I have 2 combo boxes on a form. The 1st is a dropdown with a list of trainer names from a trainers table. The 2nd combo is the same list of trainer names from the trainers table, but the combo box is called assistant.
    The user will use the 1st combo to identify the trainer of a course, and will select a 2nd trainer if they assisted in training a course.
    Both combos contain 2 columns; col1 = trainer ID (hidden), col2 = Name ie - Smith, John (calculated from [Surname]&" "&[Name])
    I have created an entry in my Trainers Table --- [ID] = 1 and [Name] = No Assistant and [Surname] = None.
    If there is no assistant, the user selects a trainer from the 1st combo, and leaves the 2nd combo that is set to a default value of 1, which displays a concatenated version of record 1 --- ie -- None, No Assistant.
    This does not look nice!
    Is there a way to display a unbound value of "None" as default if there is no assistant. I don't like the bound concatenated version of None, No Assistant showing??!!
    Regards,
    Rudi

  2. #2
    Super Moderator
    Join Date
    Jun 2002
    Location
    Mt Macedon, Victoria, Australia
    Posts
    3,993
    Thanks
    1
    Thanked 45 Times in 44 Posts

    Re: Display an unbound value in a bound combo! (Ac

    Why don't you just chnage the value in the trainers table?

    [ID] = 1 and [Name] = No Assistant and [Surname] = None.

    to

    [ID] = 1 and [Name] = "" and [Surname] = None.

    Alternatively, in the query that provides the valuesfor the combo change the concatenated field to
    Trainer : iif([id]>1, [Surname] &" "& [Name],"none")
    Regards
    John



  3. #3
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Display an unbound value in a bound combo! (Ac

    WOW John, you are being a great help here and in my other posts. thanx 4 your patience!!!
    Is it as simple as that???
    I will try it out when I get home 2night!
    Some pretty nifty answers you are supplying!
    Regards,
    Rudi

Posting Permissions

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