Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2004
    Posts
    6

    Unanswered: Problem with editable combo box

    I want my database administrator to be able to add to and delete from a combo box. The combo box is based on a table with two fields, an autonumber ID field and a text field called CourseName. I have created an editable combo box using the Not in list feature on a form that has 3 buttons plus the combo box: a delete button (I have attached some code to a command button that allows an item in the list to be deleted and to requery the list), a save button which the users wanted that saves the form, and a third button to return to the Main Menu (the switchboard). My problem is, if the user leaves the combo box display lin blank when they exit, the table gets a blank record and the combo box displays the autonumber of the blank record. Can someone tell me how to stop a record being made when the user exits with a blank display box?

    Thanks.

  2. #2
    Join Date
    Oct 2003
    Location
    Ger
    Posts
    1,969
    Provided Answers: 1
    What I understood, you dont want to show a blank record when exiting the ComboBox?
    If so, on the Exit event just write
    yourComboBoxName = yourComboBoxName.Column(0, 0)

    Which will set it on the first record

  3. #3
    Join Date
    Mar 2004
    Posts
    6
    Thanks hammbakka. I'll try this.

Posting Permissions

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