Deleting records in subform 2

[debbieg]

I have a form with a subform.

I have a Delete button on the subform. I only want the Delete button visible if the user is working in the subform. I've tried various events on both the form and subform but not coming up with the right event. How can I accomplish this?

Also, is there a way to highlight the current record in the subform to make it really obvious to the user which record they are deleting?

Thanks,
Debbie

 

[yduckfr]

1.In the eneter event of the subform control you can make the button visible and in the exit event make it unvisible

2.use conditional formatting to highlite the current record

 

[debbieg]

I finally came up with the right event.

Private Sub subfrmUniv_Enter()
    Forms!frmAlumni!subfrmUniv.Form!cmdDelete.Visible = True
End Sub

Private Sub subfrmUniv_Exit(Cancel As Integer)
    Forms!frmAlumni!subfrmUniv.Form!cmdDelete.Visible = False
End Sub

But I would still like to know if there is a way to highlight the current record in the subform to make it REALLY OBVIOUS to the user which record they are deleting?

Thanks,
Debbie

 

[yduckfr]

http://www.lebans.com/conditionalformatting.htm

Here you can download a sample mdb for highlighting the current record in subforms