470,849 Members | 1,350 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,849 developers. It's quick & easy.

Hide or disable records

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
3 2930
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
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
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

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

5 posts views Thread by Boo | last post: by
2 posts views Thread by amil [c#newbie] | last post: by
4 posts views Thread by meska | last post: by
2 posts views Thread by MAF | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.