Disable 'New Record' Toolbar button

[Haynesey]

Hi,

When the main form opens, I want the 'New Record' button on the toolbar to be disabled as I want to force users to use another button.

However, I can only do this by disabling all the command bars using the following code on the form load:

Dim i As Integer
For i = 1 To CommandBars.Count
CommandBars(i).Enabled = False
Next i

Is there any more code that will just let me disable one button?

Thanks again

Lee

 

[Haynesey]

Thanks, that worked great!

Cheers

Lee

 

[missinglinq]

In the form's Property Box on the Data tab set Allow Additions to NO

or in code

Private Sub Form_Load()
   Me.AllowAdditions = False
End Sub

Then in your other button's code to allow a new record

Me.AllowAdditions = True

After the record's saved

Me.AllowAdditions = True

Good Luck