Hi All,
I currently have a small database which contains part return information. I have had help from others on this forum and have been able to create a cascading filter form. This form takes the users inputs and creates a custom report. Currently, it will create a report with three fields, which users choose, sort, and filter on the report. I now want to do two things: Add an additional combo box to each field on the form (Total of three) that allows the users to select where the field will end up on the report (1st, 2nd, or 3rd Column). I also want to create atleast 5 more forms, each adding an additional field to add to the report. (Report with 4 fields, 5 fields, 6 fields, 7 fields, and 8 fields). I would like the filter to extend into the fields as well. The issue is I feel the programming would just be an expansion of the current form, but I have had trouble reading and understanding the current code, as I am rather new. If anyone could take a look at the form attached and help me with either the additional combo boxes or the new forms with more fields I would greatly appreciate any help whatsoever. Thanks!
I currently have a small database which contains part return information. I have had help from others on this forum and have been able to create a cascading filter form. This form takes the users inputs and creates a custom report. Currently, it will create a report with three fields, which users choose, sort, and filter on the report. I now want to do two things: Add an additional combo box to each field on the form (Total of three) that allows the users to select where the field will end up on the report (1st, 2nd, or 3rd Column). I also want to create atleast 5 more forms, each adding an additional field to add to the report. (Report with 4 fields, 5 fields, 6 fields, 7 fields, and 8 fields). I would like the filter to extend into the fields as well. The issue is I feel the programming would just be an expansion of the current form, but I have had trouble reading and understanding the current code, as I am rather new. If anyone could take a look at the form attached and help me with either the additional combo boxes or the new forms with more fields I would greatly appreciate any help whatsoever. Thanks!