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

Nov 12 '05 #1

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

Nov 12 '05 #2

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

Nov 12 '05 #3

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

Nov 12 '05 #4