Verify Field is not Null on button click

[Shadez]

Ok I have a faxing form that mass faxes from access. Next to the button to send the fax is a drop down list allowing selection of project number.

Problem: I need this button to verify that the ProjectID box has been filled before it's event is allowed to continue.

 

[rbowes]

Why don't you set the button's enabled property to False. Then on the cboProjectID_AfterUpdate() place this code:

if me.cboProjectID = "" or IsNull(me.cboProjectID)then
me.cmdSendFax.enabled = False
Else
me.cmdsendfax.enabled = true
end if


So, the button is only enabled, when the projectID combo box has a value.

Hope that helps.

Bob

 

[Shadez]

Sometimes the answer is too simple to see Thanks a ton for your help 14 hour days make me slugish.