[SOLVED] userform dynamic listbox to add & modify data

[adamheon]

in the attached example i have a userform/listbox that will pull up data from a table. i'm having the following issues:


1. when you click on an item in the listbox. it populates the MONTH YEAR & AMOUNT text boxes for that specific line item. I'd like to then be able to change the amount and update that line item. right now the code is replacing the first instance of the specific job number. so in the attached example job 08-1000 has 2 billing entries Dec. & Jan.....when you try to modify the January line item it doesn't work.

2. the combo box MONTH has a row source of MonthList. It seems like the listbox on the sample is getting the month DECEMBER from column B (based on the date entry?)...instead of pulling up the month from column I....Also the month comes in in all CAPS (UCase) not like column I is (should be December not DECEMBER). If possible i'd need to have it pull the month from Column I because potentially the "date" could be different than the month the bill was entered.

let me know if this makes sense. or if I need to clarify this more. Thanks for the help!