Userform search, amend and delete functions across multiple sheets

Hi there,

I am trying to adapt the DatabaseForm created by Roy Cox to match the requirements
of a database we are currently working on. The main difference between the original
DatabaseForm and the one i'm looking to create is the added ability to add, search,
amend and delete entries across multiple sheets within the same workbook. I would also
like to increase the functionality of the search function by giving the user the option
to add critieria to the search. I have attched the workbook.

I have so far successfully managed to implement the 'add' function across the
multiple sheets in the workbook. I am unsure what to do to the code to make the
'Search', 'Amend' and 'Delete' functions work across the multiple worksheets. The next
step I think is for me to describe what I'm hoping to achieve:

In the attached workbook, you'll see that I have three boxes (1 Textbox & 2 combo
boxes) above the listbox and the command buttons. I would like these three to be the
options available when a user is looking to search. Ideally, I would like the user to
have the ability to choose whether to use all three options or not. If they know the name of
the business, they could just put that in and hit search or they could just choose a status
and the search would return all entries that match the status from all the worksheets
and show these results in the listbox. Regardless of what the user chooses in the top
three boxes when doing a search, I would like the listbox to display information pertaining
to all three choices in the display.

When the user has performed the search and the results have shown up in the listbox, I
would like the user to be able to choose one of the entries in the listbox, this would
then automatically fill out all the relevant used fields in the userform with the information
from the entry. The user can then make changes and hit 'amend' or hit 'delete' to delete
the entry.

Any help with this will be greatly appreciated!

John

any hints or tips here would be greatly appreciated...

here's the code:

Please Login or Register  to view this content.