Filter/Then Show All

[firestorm998]

okay, so got the hang of the subform filtered by a combox concept. I've placed a datasheet view of a table as a subform on a main form and can filter the datasheet by the field CCY included in both the mainform/subform.

Change to "USD" shows me all records in the data sheet for "USD" as requested. Now i'm trying to take off the "USD" combobox filter to show all records in thew datasheet subform again. I know there are various menu filter keys but I prefer to have the menu disabled for users.

Suggestions welcome, thanks.

 

[boblarson]

First of all, to remove the filter you use

Me.Filter = ""
Me.FilterOn = False

as for disabling the menu item, I'm not sure how you would go about doing that.