Sleeper: Access button

[Inky007]

Hi

Access 2021 question

I have a student list and each have a current grade. I have a query/form where when I run the first time I get to enter the grade I’m after ie Red Belts.

I have put button on the form to rerun the report for another result ie blue belts

I can close the form & reopen it but can’t find how to pre fill the criteria question ie with Blue Belts

any help would be appreciated

thinks in advance

[June7]

I presume you are using a query with a popup input parameter. Can't 'prefill' this parameter. Must provide input from somewhere. The parameter could reference a control (textbox, combobox, listbox) on form for input.

[Gasman]

I would put all the belt grades into a combo, and just use that as criteria?

[Guanli]

Why don't you choose to aggregate the belts then use filters to get the results


color tunnel (https://color-tunnel.com)

[Couret]

To pre-fill the criteria question on your form when you reopen it, you can utilize a global variable to store the last selected grade.

[Aussiebear]

Sadly, it seems Inky007 has gone to sleep on this thread