I have a form where a user can select Location and Week No as options for a report. These are selected as ranges [From Location], [To Location] using combo boxes.
My manager has asked me to also add in location type selections using Check Boxes
In response to his request, I have assembled 5 Check Boxes on the form for the user to select. Note, the user can only select one option at a time. Their names are ChkAll, ChkAmbient, ChkChiller, ChkFreezer, ChkProduce.
If the user selects ChkAll, then all location types are reported. If the user selects Freezer, then only Freezer Locations are reported and so forth.
My current parameter query that generates the report uses the following parameters:
tart] And <=[Forms]![UF_REPORT_SELEC
kFrom] And <=[Forms]![UF_REPORT_SELEC
I already have tables with locations and locations types.
Is anyone able to help me out with this?