Hide or disable records

[Daniel Tan]

Are there anyway to hide or disable certain records that meet some
criteria ? In my app. after the quantity delivered equal to order
quantity, which means balance=0, i need to hide that record. Pls help.
Thanks.

Regards,
Daniel

[DCM Fan]

In the OnCurrent Event of the form showing such records, put code like this:

Me.AllowEdits = (Me.QtyDelivered <> Me.QtyOrdered)
Me.AllowDeletes = Me.AllowEdits

[Mike Storr]

Change the SQl of the form recordsource, or use a filter that restricts
recrds using whatever criteria you need.

Mike Storr
www.veraccess.com

Daniel Tan wrote:

Are there anyway to hide or disable certain records that meet some
criteria ? In my app. after the quantity delivered equal to order
quantity, which means balance=0, i need to hide that record. Pls help.
Thanks.

Regards,
Daniel

[Peter Doering]

On 29 Feb 2004 13:04:48 GMT, DCM Fan wrote:

In the OnCurrent Event of the form showing such records, put code like this:

Me.AllowEdits = (Me.QtyDelivered <> Me.QtyOrdered)
Me.AllowDeletes = Me.AllowEdits

^^
Me.AllowDeletions

Peter