Hi Access folks/folkesses,

I am getting to know the chap12 solution Project Tracker database and in the projects for the listboxes don't clear when you click 'Add New'. I wondered if anyone had managed to find a solution to this in vba or if anyone know how to in this case.

The listboxes for Comments, Contacts and Attachments are embedded in the tabcontrol. The remaining controls on the form clear via a routine which clears first the object and then the form control.

It does not work to use simple code like the following
    'clear the List boxes
    'lstComments
    [Forms]![frmProjects]![lstComments].Value = ""


Looks like a bug for Wrox. Please help.

trancelife

I found a solution to this:

put the following code (after declaring the vars) in ClearProjectsControls:

    'clear the List boxes
    'clear lstComments
    lngListCount = Me.lstComments.ListCount
    For intCurrentRow = 1 To lngListCount
        Me.lstComments.RemoveItem (0)
    Next intCurrentRow

    'clear lstContacts
    lngListCount = Me.lstContacts.ListCount
    For intCurrentRow = 1 To lngListCount
        Me.lstContacts.RemoveItem (0)
    Next intCurrentRow

    'clear lstFileAttachments
    lngListCount = Me.lstFileAttachments.ListCount
    For intCurrentRow = 1 To lngListCount
        Me.lstFileAttachments.RemoveItem (0)
    Next intCurrentRow