Results 1 to 4 of 4

Thread: reseting combo boxes to null values

  1. #1
    Join Date
    Jun 2003
    Location
    Bloomington, IN, USA
    Posts
    116

    reseting combo boxes to null values

    Ok, I have a form for enrolling employees into training sessions. The way it works is you select the training course you want to enroll in, it then enables the combo box with employee names in it, you select your name, click the button and your enrolled. All that works good so far.

    However, what I would love to make happen is this: if you want to put in more than one student at a time, I would like for the combo box with the employee names in it to reset to its previous blank setting after the button is clicked. I can find no way to acomplish this, and would appreciate any input on the matter.

    And just so it's stated, I'm useing Access 2k2 and VBA.

    Thanks
    Brandon

  2. #2
    Join Date
    Aug 2003
    Location
    Singapore
    Posts
    3
    Hi there
    Are u able to use this code after the OnClick event??

    Me.YourComboBox = Null

    Cheers

  3. #3
    Join Date
    Aug 2003
    Location
    Bellville, TX
    Posts
    3

    Muliple Selections

    The cool way of selecting mulitples is to use a multi-select list box and do many at the same time.

  4. #4
    Join Date
    Jun 2003
    Location
    Bloomington, IN, USA
    Posts
    116
    yes, that is quite cool, however it would completly give a heartattack both to my program matrix, and to the less-than-computer-savvy users I am designing this database for.

    Brandon

Posting Permissions

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