Set Command Button Not to Work Unless Certain Fields Contain Data

[mick3911]

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

[ranman256]

put events in all the AFTERUPDATE events to enable the button

sub txtInvestFind_Afterupdate
  EnableBtn
end sub

 
sub txtRoot_Afterupdate
  EnableBtn
end sub
sub EnableBtn()
  btnEmail.enabled = Not IsNull(txtInvestFind) and Not IsNull(txtRoot)
end sub

[CJ_London]

cross posted here with responses https://www.access-programmers.co.uk...=1#post1608172

@mick - please read this link about the etiquette of cross posting http://www.excelguru.ca/content.php?184

[mick3911]

Many thanks

[mick3911]

@mick - please read this link about the etiquette of cross posting http://www.excelguru.ca/content.php?184

Noted, apologies.

[Gicu]

Why not leaving the button enabled and adding the check and a message in the OnClick event of the button?

If IsNull(txtInvestFind) Or IsNull(txtRoot) then
   msgbox "Please fill in ,,,,,,"
   exit sub
end if

Cheers,
Vlad

[Micron]

IsNull is fine as long as there's no chance of the field containing an empty string. Would also consider a different approach if the count of fields to be evaluated gets larger. I usually would employ a routine that loops certain controls right from the beginning. It's easily expanded and beats re-writing code when you suddenly decide you need to add 2 more.

[mick3911]

Many thanks for the help. Now sorted.