aloy78
07-14-2012, 10:30 PM
Hi all,
I'm trying to create a userform to edit my records that are different sheets. I have no problem adding but to edit it is a different story altogether :)
What I need is basically I will have a drop down list (just like the one in my add record button), which enables me to select the sheet I want to edit. Then i type in the Record No and click "Search Record No", and it will retrieve the existing data. All I have to do next is amend my data and click "Save Record" to amend and save my changes.
I have attached my file for your review.
I'm trying to create a userform to edit my records that are different sheets. I have no problem adding but to edit it is a different story altogether :)
What I need is basically I will have a drop down list (just like the one in my add record button), which enables me to select the sheet I want to edit. Then i type in the Record No and click "Search Record No", and it will retrieve the existing data. All I have to do next is amend my data and click "Save Record" to amend and save my changes.
I have attached my file for your review.