Microsoft Access - Access logbook - Asked By anu anu on 25-May-12 06:40 AM

hi ,

 i wants  to make the service logbook in access 2007 . i have below fileds in my logbook

call sheet
ID customer name call date call type caller name phone no closed date remarks Status
8 dfldf; 5/25/2012 cr sdgsag 1321313
dfsgfkskf Open
9 sdjskdhkj 5/25/2012 pm hdjsdj 12131 5/25/2012 dsfkjsdkfj Closed
10 dbfjsdfkj 5/25/2012 cr dsjfsdjfl 121321
dsjfsdfsdfjl Open
11 fd;skfsdk'; 5/25/2012 ijf jfldsjfl 13232 5/25/2012 ekjfekf;s Closed

 

i want whenever we put status closed ,abort or cncl.closed date must be punched ,if by mistake we forget punch the closed date error display in screen. and also when id closed cncl .abort the whole row freeze after that nobody change in that ID.

Pat Hartman replied to anu anu on 27-May-12 12:06 AM
You'll need code in two form events.
In the Form's Current event:
If Me.Status = "Closed" Then
  Me.AllowEdits = False
Else
  Me.AllowEdits = True
End If
In the Form's BeforeUpdate event:
If Me.Status = "Closed" Then
  If Not IsDate(Me.ClosedDate) Then
    Cancel = True
    Me.ClosedDate.SetFocus
    Msgbox "Please enter date closed.",vbOKOnly
    Exit Sub
  End If
End If