Deletion based on combo box in Continuous Forms.

[sd110404]

Hi,

I have a Continuous Forms with few fields (Item is combo box and Amount is text box which needs to be entered) in it..

Item Amount
Payment 300.00
Sample 100.00
Extras 150.00

So on...

Deletion and edition shouldnot be allowed on Payments Item.

Forexample, I should be allowed to enter select Payment from item combo box and enter an amount for it. But shouldnot be able to delete (Me.allowdeletion) that record and edit the amount.
Is it possible to do this? How can i code this?
Thanks for any answer.

 

[KenReay]

Hi

If you do not want to allow Deletions at all using the form, then set .AllowDeletion = False, if yo want to disable deletions depending on the type of payment, then code in the OnDelete even something like so should do it:

If Me.MyCombo = "Payment" THen
Cancel = True
End If

using your own control name of course

Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK