Hello all
Many thanks for any help offered here. I am sure this is not the right way to do this but this is what I have done so any help gratefully appreciated. I am not a database manager, developer or programmer but a stupid physician grappling with Covid patients and trying to setup a database to streamline care.
I have a patient database with a field caller Trigger_Date. My team access, input and work through mostly through a single form. I want a Toggle Button to apply a filter that only displays records where the Trigger_Date has passed. I am crap with VBA or expressions so used the lowly macro builder.
I inserted a Toggle Button from Control Bar and OnClick embedded the macro ApplyFilter Where Condition = [Trigger_Date] < Date().
Control Name is blank, don't even know what this is for.
Works great, depress the Toggle Button with one click and form filtered. However or repeat clicking the form remain filters despite Toggle button reverting to undepressed state.
Only a small thing but I am trying to build a future proof-ish form for a large team of docs and nurses of varying IT skills so this will make a difference.
Many thanks in advance.
Emmet
Many thanks for any help offered here. I am sure this is not the right way to do this but this is what I have done so any help gratefully appreciated. I am not a database manager, developer or programmer but a stupid physician grappling with Covid patients and trying to setup a database to streamline care.
I have a patient database with a field caller Trigger_Date. My team access, input and work through mostly through a single form. I want a Toggle Button to apply a filter that only displays records where the Trigger_Date has passed. I am crap with VBA or expressions so used the lowly macro builder.
I inserted a Toggle Button from Control Bar and OnClick embedded the macro ApplyFilter Where Condition = [Trigger_Date] < Date().
Control Name is blank, don't even know what this is for.
Works great, depress the Toggle Button with one click and form filtered. However or repeat clicking the form remain filters despite Toggle button reverting to undepressed state.
Only a small thing but I am trying to build a future proof-ish form for a large team of docs and nurses of varying IT skills so this will make a difference.
Many thanks in advance.
Emmet