Xx_TownDawg_xX

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

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