Hi All

[zoona]

First post, I have been given this database to 'fix' I have not used vba before, some the VB code works, then fails. It should email out a the form as requested it seems very simple I hope. I can tidy the DB myself but I can not get this to run at all.

Thanks

 

[mrojas]

You have complicated things more than needed.
Change the query and code behind button as shown on revised database.
The report's query has as its criteria the form's client ID.
The send report command takes the email address from the form.