Don't want the delete button on a subform with a new record

[sneuberg]

I have a main form with a subform in continuous format. The subform displays the list of records and has a delete button allowing the user to delete that line (record) All works except if the user clicks the delete button on the new record line. This results in the error, “The command or action DeleteRecord isn’t available now”. This makes sense as this new record doesn’t exist. I’d like to have the delete button only appear on the subforms with records that have been saved and not on the subform with the new record. I can’t seem to find the right events to make this happen. I tried putting the code below in the subforms on load event, but when that fires it make the button disappear on all of the subforms. I could use some help.

If Me.NewRecord then


Me.DeleteBTN.Visible = False
End IF

[June7]

This won't work because the form is continuous (or datasheet) and there is only one button. Changing the property affects all instances of the control.

Try the OnCurrent event.

Or maybe trap the error with an error handler.