Disable new blank record

To disable the creation of new blank records in a table, you can use the following methods:

Method 1: Using the "Allow Additions" property

1. Open the table in design view.
2. Right-click on the table and select "Properties" from the context menu.
3. In the "Table Properties" dialog box, click on the "Data" tab.
4. Uncheck the "Allow Additions" checkbox.
5. Click "OK" to save the changes.

Method 2: Using a macro

1. Open the table in design view.
2. Create a new macro by clicking on the "Macros" button in the "Developer" tab.
3. In the "Visual Basic Editor", create a new module by clicking on "Insert" > "Module".
4. Add the following code to the module:

   Private Sub DisableAdditions()
    DoCmd.SetWarnings False
    DoCmd.Hourglass True
    DoCmd.RunCommand acCmdDeleteRecord
    DoCmd.Hourglass False
    DoCmd.SetWarnings True
   End Sub

5. Save the module and close the Visual Basic Editor.
6. Open the table in form view and click on the "Run" button to run the macro.

Method 3: Using a form

1. Open the table in design view.
2. Create a new form by clicking on the "Forms" button in the "Developer" tab.
3. Add a button to the form and set its "On Click" event to the following code:

   Private Sub Command0_Click()
    DoCmd.SetWarnings False
    DoCmd.Hourglass True
    DoCmd.RunCommand acCmdDeleteRecord
    DoCmd.Hourglass False
    DoCmd.SetWarnings True
   End Sub

4. Save the form and close the Visual Basic Editor.
5. Open the form in form view and click on the button to run the macro.

In all cases, the "DisableAdditions" macro will delete the current record when the user tries to create a new blank record. This will prevent the creation of new blank records in the table.