Pointing a specific line in a continuous form

[Maracay]

Hi Guys,

I am using a continuous form as subform, I am using the table fields in this
subform, the user needs to click on a check box to mark the record as deleted
and input the date the record was delete, some times the user doesn’t include
the date but I don’t know how to point the specific record and tell the user
in what line of the subform is the error.

Thanks

 

[John W. Vinson]

Hi Guys,

I am using a continuous form as subform, I am using the table fields in this
subform, the user needs to click on a check box to mark the record as deleted
and input the date the record was delete, some times the user doesn’t include
the date but I don’t know how to point the specific record and tell the user
in what line of the subform is the error.

Thanks

Why make the user type today's date? Just fill the date field in automatically
in the checkbox's AfterUpdate event. Use a SetValue macro or VBA code like

Private Sub chkDeleted_AfterUpdate()
Me!txtDateDeleted = Date
End Sub