Recent content by Vomba

Or in the NoData event just type Cancel = True Unless you have a specific reason for not using this method, obviously!:D

Hi Not sure about using Access 2007, but I use something along the lines of this, called when the Startup form is first opened. Public Sub LogAccess() Dim rs As DAO.RecordSet Set rs = CurrentDb.OpenRecordset("tbl_AccessLog") rs.AddNew rs![strUserID] = Environ("username") rs![strPCID] =...