Help with filters

[jamesscully]

Hi, I am an amateur who has written a few Access databases for my business, very complicated and difficult but the end result is worth the effort. I am struggling with filters. I want to apply a simple filter to my datasheets whenever I open them, and once they are open I want to be able to apply different filters using the built in filter options. What is the simplest way to set a filter that is applied whenever the datesheet is opened or get the focus? I use a tabbed "home page", each tab displays a different datasheet, so not sure if this means they are all datasheets are "open" when I start up the database. Im strictly queries and macros, no code! Please help!!

[Welshgasman]

Use the Access built in filtering. Right click on a control.

[CJ_London]

If you mean data sheet forms You can apply a filter when you open a form - it is the where parameter of docmd.openform

A user can remove the filter once the form is open

If you mean the data sheet view of a table or query, you can set it as a property - but it cN be easily removed by accident

[jamesscully]

I do mean datasheet forms. Can you explain how/where I enter the parameter docmd.openform please. I have a field on that form called Order Status and I want the form to open with only orders with an "open" status showing.

[Welshgasman]

I have Google on this laptop.
First link from the Google. https://docs.microsoft.com/en-us/off...docmd.openform
Google. https://www.google.com/search?q=docm...hrome&ie=UTF-8

However you say you have multiple datasheets?, so unless they all have the same field, this is not going to work?

[CJ_London]

You need a form to open another form - typically on a button click event . The event can use vba or a macro. I don’t use macros but pretty sure openform will be an option. Think there is a wizard which will open when you create the button to create the macro- just follow the prompts

There are other ways - add a button to a ribbon or create a hot key macro but suspect these are not appropriate to your requirements