Mar 13 2020 08:35 AM
I am having an issue with trying to have a field require mandatory input. Within a Form that I have established via the Customize Ribbon--> Developer--> Forms option which is assigned to the Table created to house the inputted data, I need for a field to require mandatory input. The Form will ask for a Date, number of Accounts, and number of Forms. Within the Forms field (columns/rows F8:F17) I need for the user to be required to input a value of Zero (0) and above. This field cannot be left blank. Also, within this field (columns/rows F8:F17) I have assigned Data Validation that requires the number in this field to not exceed the number in the Accounts field (columns/rows E8:E17). Any search online for a VBA code has proven unhelpful. The one I found and tried inputting keeps returning a Compile error: Expected: end of statement response. Since I am not skilled at all on VBA I am at a standstill. I have attached a screen shot for reference. Can someone please assist? I would greatly appreciate it.
Mar 13 2020 09:56 AM