Thanks for your help guys but I think this is bigger than I can handle with
my knowledge.

"JLGWhiz" wrote:

I don't know why you would get a VBA error 400, which is telling you that
you are trying to open a form that is already open. There is nothing in the
code that Joel provided that calls a form to Load or Show. If you click the
Debug button when the error message appears, which line of code is
highlighted?


"Ben" wrote in message
...
The only thing I forgot to say was that the sheet with all the data is
call
"Voucher Records". Would that make a difference?

"JLGWhiz" wrote:

This is the message for a Err 400:

You can't use the Show method to display a visible form as modal. This
error
has the following cause and solution:

a.. You tried to use Show, with the style argument set to 1 - vbModal,
on
an already visible form.
Use either the Unload statement or the Hide method on the form before
trying to show it as a modal form.

So, since there is no form involved in the code Joel provided, the
question
arises, is there something you forgot to include in your original post?



"Ben" wrote in message
...
Hi Joel

The macro does not work. I get a 400 error