form validation

[sharonir22]

hi
I created a form with several different fields. I have a button that allows to save the record and close the form. I want to create a code for the click option that checks if all the fields are filled and doesn't allow you to save the recordif there are empty fields.

I tried doing it in an if statement but it was very long and didn't work.
I would appreciate a written code or any kind of help
tnx

[June7]

Options:

1. set each field as Required in table properties then let Access nag the users - they will learn to make sure everything is filled in

2. VBA code as you attempted - post your code for analysis. What does 'didn't work' mean - error message, wrong results, nothing happens?

[ranman256]

Put this in to validate the form before saving data...

Sub btnSave_click()

if IsValidForm() then
   'Save
   'CLose form
End if
End sub

private function IsValidForm() as boolean
Dim vMsg 

Select case true 
    Case isNull (txtName)
          VMsg = "Name is missing"
    
     case isNull(cboState)
              VMsg = "State is missing"   
 
     Case txtPass1 <> txtPass2
            VMsg = "Passwords don't match"   
End select

IsValidForm= vMsg= ""
if vMsg <> "" then MsgBox vMsg,vbCritical, "Reqd Field"
end function

[orange]

In Access fields are in tables, controls are on Forms.
Entered data can be validated in the BeforeUpdate event of the Form.
Here are some reference links
http://www.blueclaw-db.com/access_ev...foreupdate.htm
https://msdn.microsoft.com/en-us/lib.../ff822421.aspx

Good luck.

[Missinglinq]

As orange has suggested, the Form_BeforeUpdate event is the usual place for validation code that checks to see that one or more Controls are populated, before allowing the Record to be saved. It's fine that you have a custom 'save & close' Command Button, but Access will, by default, save a Record if the user navigates to another Record, closes the Form or closes Access, itself!

My usual advice, if a developer really needs a 'save' or 'save & close' button, is to use the button to do just that, save the Record and and close the Form. This will send Access to the Form_BeforeUpdate event, where you can validate the Control(s) and act accordingly, Cancelling the Update, if need be, so that corrective action can be taken.

Linq ;0)>

[sharonir22]

I made the first problem work but I also want to make sure that if a user exits the form by closing it and not through the save button, the record will not be created in the database
Help?

[June7]

Disable the form X close. Also disable the right click shortcut menu by Option settings.

Can also customize the ribbon to disable app X close and menu Exit but this is rather advanced coding.

[Missinglinq]

Then you need to do the validation in the Form_BeforeUpdate event, as stated! Regardless of how you leave a Record, by moving to another Record, closing the Form or closing Access, itself, after the Form has been dirtied, the Form_BeforeUpdate event will fire!

Linq ;0)>