Now that I've reread the thread, I'm confused.

Do you want to lookup in the userform and edit the values?

Or do you want the Report generated?

Or do you want both?