Hi Dieselrocks. Sounds like a refresh interval problem, particularly if the tables are linked via ODBC.
Access loads a form's recordsource - its recordset - when it is first opened. In a multi-user environment it automatically refreshes the form periodically to show modifications and changes to records, at specific refresh intervals specified in the Tools, Options, Advanced settings of the database itself.
You can force a form to refresh manually using the Records, Refresh menu option - and if you try this when the form is showing some records you know you have deleted you will be able to tell for certain by their subsequent disappearance if it is or is not a refresh problem.
The two database settings of interest from the Tools, Options, Advanced tab are the refresh interval (which will apply if your tables are linked directly to another Access database), and the ODBC refresh interval (which will apply if you are linked via an ODBC driver). The defaults are 60 seconds for the normal refresh interval and 1500 seconds for the ODBC refresh. So, somewhat incredibly, for ODBC it can be more than 20 minutes before Access will refresh an open form to show any modified records, new records, or deleted records.
Check the settings for your database, and if your DB is linked via ODBC try reducing the setting to something more sensible than 1500 seconds.
PS Access tables are not intended for direct access by users, although it can be a quick'n'dirty method for developer use. Deleting records directly in a table or in code bypasses the forms environment until the next refresh and is not really recommended as the norm unless you are prepared to implement automated refresh using VBA or the like.
-Stewart
19
