Disabling Delete Button

[Guest]

I have a form where user can only add and delete records (no edits are allowed), all work well
It is just that one thing that don't really satisfy me ,which is to disable the delete button when user is adding new record that has not yet comitted or where there is no record at all. and to enable it when it is pointing to a record

Many thanks in advance
Djoezz

 

[Mark]

Hi,

There is a Form property called NewRecord that returns true when adding a
new record.

So if you put code like the following in the form's current event then the
delete button would be disabled and enabled:

If Me.NewRecord Then
Me.cmdDelete.Enabled = False
Else
Me.cmdDelete.Enabled = True
End If

Note. change the cmdDelete to the name of the delete button.

HTH

--

Cheers
Mark

Free Access/Office Add-Ins at:
http://mphillipson.users.btopenworld.com/

I have a form where user can only add and delete records (no edits are allowed), all work well.
It is just that one thing that don't really satisfy me ,which is to

disable the delete button when user is adding new record that has not yet
comitted or where there is no record at all. and to enable it when it is
pointing to a record.

 

[Guest]

Thanks Mark, it works perfect!