Re: prevent deletion of record
- From: Marshall Barton <marshbarton@xxxxxxxxxx>
- Date: Tue, 23 Aug 2005 14:15:18 -0500
Yes, you can add lots of stuff to a procedure. This one
line is quite independent of most things so it should not
intefere with any thing else. The one exception would be if
your delete button has the focus, in which case you would
need to set the focus to some other control before disabling
the button.
--
Marsh
MVP [MS Access]
Sue wrote:
>I already have an Event Procedure controling the change of another field in
>the On Current property. Can i add another line to that On Current Event
>Procedure?
>
>
>> Sue wrote:
>> >I have a form that displays previous year's info at top w/ space to enter new
>> >info current year info at bottom. I would like to prevent the deletion of
>> >the record if there is a value greater than '0' in the previous yr value.
>> >There is a deletion button on the form.
>>
>"Marshall Barton" wrote:
>> I think I would disable the delete button if the prev yr
>> field >0 using the form's Current event:
>>
>> Me.btnDelete.Enabled = (Me.[previous yr] > 0)
.
- References:
- prevent deletion of record
- From: Sue
- Re: prevent deletion of record
- From: Marshall Barton
- Re: prevent deletion of record
- From: Sue
- prevent deletion of record
- Prev by Date: Re: Postion in a List Box
- Next by Date: Re: How Can I Pre-Process Data in a Bound Control?
- Previous by thread: Re: prevent deletion of record
- Next by thread: RE: prevent deletion of record
- Index(es):