filter command button

[FRAZ]

I have a continious form, that I would like to filter. What I'm looking for is a way to simulate the filter icon on the main menu by using a command button. I've tried the run menu command put I get an error that say command is not available.

thanks

[June7]

Options:

1. parameterized query, review http://datapigtechnologies.com/flash...tomfilter.html

2. VBA to construct and apply filter criteria string, review http://allenbrowne.com/ser-62code.html

[FRAZ]

thanks for the valuable information, however what I was looking for is a simple way do duplicate the filter routine that is found on the data sheet view. For example in data sheet view you click on the header and a drop down list appears to select filter criteria. I would like to do this on a continious form.

[June7]

The options I referenced are just about the closest you will get. However, take a look at this https://www.accessforums.net/forms/b...ria-40775.html