X
Reaction score
3

Profile posts Latest activity Postings About

  • OK Good. You might also require that the field for the disposition is filled in before closing the form

    Close click event


    If IsNull (Me.SubjectCtl) Then
    Msgbox "Please Fill In The Disposition!"
    Me.SubjectCtl.SetFocus
    Exit Sub
    End IF

    'Your close code goes below



    Richard
    OK Good. You might also require that the field for the disposition is filled in before closing the form

    Close click event

    Code:
       If IsNull (Me.SubjectCtl) Then
    Hi Chris,

    I notice a difference in the number of records returned by the qry_DataEntry query (195) and the tbl_DataEntry (214) and wondered where you might be missing data. The field in the "Disposition" field in records 169, 173, ... are missing data. They must be filled in with SCR, RWK*, RWK or UAI. You can find those records by building a query using the tbl_DateEntry as the query's table, then place the tbl_DataEntry.* as one of your fields. Then place the field Disposition next to it then type Is Null for the Criteria in the Disposition field and the query will return all records that have the missing data.

    Hope this helps


    Richard
  • Loading…
  • Loading…
  • Loading…
Back
Top Bottom