Charlize
08-02-2006, 06:22 AM
I am able to do a search with autofilter by using a form. It shows the rows that contains the values that are submitted (a maximum of 7). I can populate a listbox with only the visible items in a listbox (i would also like to have the columnnames ???).
But when I click or double click the row in the listbox I need to change one value (column 7 - location of a book). This changed value (or the whole row) has to be rewritten to the row that contained the previous value.
Any idea's ... Listindex ? Rowno ?
ps.: The rows in the listbox are not added via rowsource.
But when I click or double click the row in the listbox I need to change one value (column 7 - location of a book). This changed value (or the whole row) has to be rewritten to the row that contained the previous value.
Any idea's ... Listindex ? Rowno ?
ps.: The rows in the listbox are not added via rowsource.