Ms access 2007 macro actions

[sireesha]

i have a form. save button is placed i.e., embedded macro. In the form all the fields are mandatory. for all mandatory fields give message "Required field name........" . In macro isnull(fieldname)=true and action give message after gives a message macro will stop with out saving the record. message given and also saved into table. i don't want when i click the save button if all fields are entered saving is done otherwise give message and then stop the macro and cursor will placed on particular required textbox . Please give me solution for this.



i tried with code also but its not working please help me.

[pbaldy]

This is the way with code:

http://www.baldyweb.com/BeforeUpdate.htm

Why not make the fields required in the table?

[sireesha]

i need macro actions on save button or code on save button. when i click on save button give message "required field...",if all fields are entered it will save otherwise not saved .cursor blinks on particular field. please help me.

[pbaldy]

I did help you, you just didn't read the link.

[sireesha]

i tried. its not working. the code is on form_beforeupdate but i need on save button. my form is in datasheet view. i need to check with second row.how please help me. and not a one field somany fields are there in my form. for all fields i want to give message. directly go to else part record is saved. if all fields are not entered give message no need to save

Private Sub Save_Click()
If Me.fieldname= 0 Then
MsgBox "You need to fill out fieldname"
Cancel = True
Else
DoCmd.RunMacro "macro1"

End If
End Sub