Printable View
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
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.
I would put all the belt grades into a combo, and just use that as criteria?
Why don't you choose to aggregate the belts then use filters to get the results
color tunnel
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.
Sadly, it seems Inky007 has gone to sleep on this thread