I want to add "Find & Edit" button and also a "EditNewRow_checkBox" to User from , This button will work on this four textboxes below
-------------------------------------------
Datebox | ServiceNo | UserName | Product
-------------------------------------------
the find button will have the property of editing/correcting the SAME ROW,
if user search for ServiceNo for eg 123 of past month the Userform will auto populate the other texboxes like Datebox , UserName, Product falling in same row of table and he can edit it and the corrections made will remain on that row only.
But * about EditNewRow_checkBox
when the user have completed finding ServiceNo (the S...No may be of past Month may be it was on HOLD for some reason but now he have to complete that service ) so user want this to be edited but not on the same row. the editing when it is completed it should automatically go and dump itself in lastrow of table . ( in here the Hold service no in past month should be their itself but EDITED one should be dumped in lastrow of table )
i know its confusing .
actually i am tyring to do some thing like EXCEL Find app ... in which Find ALL kind of option also should be their.
Please Help. with code. if possible
Thanks in Advance
Bookmarks