no warning empty row form 1

[matrixindicator]

I have a delete command on each row of a subform. It works fine. If the users clicks an empty row access giving an error dialog box to say that he can not delete an empty row.

How can I say, if it is a empty row do nothing and do not show an error dialog box (docmd.setwarnings false ?).

Forms!F01_ORDER!FS_T02_ORDER.SetFocus
DoCmd.SetWarnings False
DoCmd.RunCommand acCmdDeleteRecord
DoCmd.SetWarnings True

 

[PHV]

Test the value of the PK control.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[matrixindicator]

don't know what you mean and how to ?

 

[PHV]

Perhaps something like this:

If Trim(Forms!F01_ORDER!FS_T02_ORDER & "") <> "" Then
  DoCmd.RunCommand acCmdDeleteRecord
End If

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[matrixindicator]

I need to check if there is a record, an empty record requires no action. PHV, one your action he is complaining and on my code trial below also. What is missing ?

If IsNull(Forms!F01_ORDER!FS_T02_ORDER) Then
Else
DoCmd.SetWarnings False
  DoCmd.RunCommand acCmdDeleteRecord
DoCmd.SetWarnings True
End If