• Need to initialize the another combo box (2000)

    Home » Forums » AskWoody support » Productivity software by function » MS Access and database help » Need to initialize the another combo box (2000)

    Author
    Topic
    #418878

    I have two independent combo box on a form that selects a record based either by company number or company name and the work fine. The form displays company information name and address, and it has a sub form that lists that the purchase orders and other related information (a one to many relationship). I have a button that prints the a report of the information on the form.

    If open the form my two selected combo boxes at a null. I obtain the record for client x via the name of client x by the combo (cbo1). However if I then go to the combo box (cbo0) that selects the record by client number, the combo box (cbo1)still retains the name of the previously selected record.

    Private Sub cbo0_AfterUpdate()

    Viewing 0 reply threads
    Author
    Replies
    • #944106

      If you want to set the combo’s to Null, use the On Current event of the form :
      Private Sub Form_Current()
      Me.cbo0=Null
      Me.cbo1=Null
      End Sub

    Viewing 0 reply threads
    Reply To: Need to initialize the another combo box (2000)

    You can use BBCodes to format your content.
    Your account can't use all available BBCodes, they will be stripped before saving.

    Your information: