Check for NULL text box when clicking save on form

[cwwaicw311]

Hi, is there feature whereby when i click on the save button, if there is a textbox which is empty or null the form would not save??

I also have another question is that, is there somehow when i open the form page which i have created, normally the when we open the form it would appear the first record of the form (for example 1 of 6). So my question is that is there any setting when i open the form i would be a new record page where i can straight enter information into the form without clicking to a new page??

[maximus]

Answer to you second question go to Form Properties, Click on Data, Select Yes. Generally this option for a Form is No by default. Checking this option Yes will always open your form in a data entry mode i.e. a blank form.

Answer to you first question. I will assume yu alreadyhave a save button on your form. Go to the command Button Properties, Select event, Then select OnClick event and open the Vb code of the button. You will find a code very similar to one below:

Private Sub Command6_Click()
On Error GoTo Err_Command6_Click

If IsNull(Me.Inventory) Then
MsgBox "The inventory field is blank", vbInformation
DoCmd.GoToControl "Inventory"
Else
DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70
End If

Exit_Command6_Click:
Exit Sub

Err_Command6_Click:
MsgBox Err.Description
Resume Exit_Command6_Click

End Sub

The part of the code in red is already there. Please type the code in black.

I have a form in which there is a field called inventory. If it is null a msgbox is displayed and the cursor moves automatically to the inventory field.

[RuralGuy]

Another method, and one I prefer, is to place all such validation code in the BeforeUpdate event of the form. That event can be cancelled if some validation fails and fires regardless of how the form is closed.

[cwwaicw311]

thank for help guys....

[maximus]

Yes I agree with Rural Guy on this to coz the validation code will not help you if you have a close button activate on your form. even if validation fails the user can still close the form and the data is saved in your table. More over even if you create a close Command button on your form and place the validation code in its Onclick event and de-activate the close on button on the form the user can still close the database and the unvalidated data is saved in your table. So BeforeUpdate even is much more safe.

[RuralGuy]

thank for help guys....

Is this thread ready for you to follow the link in my sig and mark as Solved?