I have a userform that I use to enter fault calls and it saves in to a spreadsheet.
I want to develop the capability to be able to have a form that Will search a pre-existing call and then when it finds it to bring up the main userform and populate it with existing details so that the user can amend them if reqd and save back to the database.
So what i want.
Userform - New Call
Userform - search existing call
I want to open 'search existing call' userform, be able to search based on one of the following: callrefnum, fault_type, Call_logged_by
Once the call is found - it should be displayed and then on double click it shd open up in the main userform 'New Call' with all existing details populated.
Any help or reference to a thread which answers this will be appreciated.
Thanks!
PJ
I want to develop the capability to be able to have a form that Will search a pre-existing call and then when it finds it to bring up the main userform and populate it with existing details so that the user can amend them if reqd and save back to the database.
So what i want.
Userform - New Call
Userform - search existing call
I want to open 'search existing call' userform, be able to search based on one of the following: callrefnum, fault_type, Call_logged_by
Once the call is found - it should be displayed and then on double click it shd open up in the main userform 'New Call' with all existing details populated.
Any help or reference to a thread which answers this will be appreciated.
Thanks!
PJ