Hi Vaticus

You have three(3) sheets of data ("Pending Submittal", "Pending Stamp" & "2YR Hold"). I understand that any individual Patient Name CAN appear on each individual sheet BUT, will any individual Patient Name appear MORE than once on any individual sheet?

If NO why do you have five(5) Status Textboxes in the Report UserForm.

If YES what if the individual Patient Name appears MORE than five(5) times in those data sheets?

Why are you searching on Name rather than SSN Number?

Do you not have a Patient List to use as a source? This CAN be built from the three (3) sheets of data but I'd assume it's already available to you.

I'd use a ComboBox rather than a TextBox for the Patient Report search form and populate the ComboBox with the Patient List allowing for duplicate last names and the MatchEntry feature of the ComboBox.

Some thoughts for you to ponder...I'll work on this with you...let me know your thoughts.