Cant Modify Data with User Form - Help with code!

Hi

The problem is when i open the "Update Records" Form i can select the record with a list box which works OK however when i edit the records and click the button "EDIT" it does nothing!

i've copied the code from a previous post and added some values and columns however the EDIT options is the only one not working.. IMPOTANT: i dont want to modify only the first field, i want all of them to be modify if the data is different if the same, just paste the same info.


I'm new at this VBA stuff... your help is greatly appreciated!

Please Login or Register  to view this content.

ScanDB.xlsm

THANK YOU!!!

HI Leith

im getting an error "Run Time Error 1004: "Application or object defined error"

will it be possible for you to upload a workin example?? if not please guide me in how to fix that.

Thank you so much in advance!

when i click on the button in order to show the form its when it happens, so i guess its in the Initialize Code.

There is something weird with the FrmEditData object name... it doesnt let me change its name!

Found it, for some reason its looking in the INPUT page and cant finde the object that is why in debug calls the ".show"

Add the following in the macro calling the form.

Please Login or Register  to view this content.

and it should open the form.. however the combobox is adding "A2:A100" as a list.. can you modify the code to only show nonblank cells??

THanks!!!!!!

Never mind mate, the mistake was in my end.. now its fully functional!

THANK YOU so MUCH!!!!!!!!!! really!