Set Command Button Not to Work Unless Certain Fields Contain Data (1 Viewer)

I have a form where there is a Command Button to e-mail a report.
What I would like to happen is that the Command Button will not function unless the Investigation and Root Cause fields on the form have had data entered into them.

Command Button is named: View/Send Report
First field that I want to have data in is named: Investigation Findings
Second field that I want to have data in is named: Root Cause

Is this possible, if it is how do I go about doing it?

I’m guessing that it can be done by VBA but my VBA knowledge is not that great.

Many thanks

it is not a good idea to have spaces in names as VBA will not recognise them and will either fail or substitute an underscore . Similarly none alpha numeric characters can cause issues- so in my example I have removed them. You will need to put them back if required

in the form create a sub called say disableButton

then in your form current and the after update events for the InvestigationFindings and RootCause controls just put

Hi CJ_London

Thanks for your reply.

How do you mean create a sub in the form?

open form in design view
open properties
on the dropdown, select form
click on the events tab
on the current event, click the carat to the right and choose code

that will get you into the vba editor at the right place for the form current event