Prevent deletion of record depending on a field value

S

Saeed

I have a sub form which show data in a multi-row format. Each row has 3
columns, Item, Qty and DateReceived.

I want to prevent deletion of rows if the DateReceived is not null upon
query of the data. Deletion/updates can be done if this value was null
when the data was queried. This is so that is the user enters a value by
mistake then decides to change it or remove the row they can.

What I need then is some way of deactivating DELETE/UPDATE when
navigating to each record in the sub form.

I'm pretty sure I can come up with the code but aren't sure which event
to look at.

Saeed

ng_786
 
Top