Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

empty row form no warning

Status
Not open for further replies.

matrixindicator

IS-IT--Management
Sep 6, 2007
418
BE
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 ?).

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



Please post MS Access questions in one of the many MS Access forums like forum720.

Skip,
[sub]
[glasses]Just traded in my old subtlety...
for a NUANCE![tongue][/sub]
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top