Hello,
I have been working on an Access database that has several tabs with each tab having several controls/fields. Some of these controls/fields are to be "required" for data entry (but not using required attribute in the table). Also, on the form there is a command button for users to click to print a report using data from all controls.
Now, when users click the "Print Report" button, I want the database to check if the "required" fields have data in them. If not, another form opens and asks the user if they want to enter the missing data for that particular field or cancel the entire report and close database. When a user clicks continue, the "popup" form closes and focus is sent to the field with the missing data. However, here is the problem. The macro I have running to check the fields generates several "popup" forms for each field missing data, all at the same time. I would like the macro to generate only one "popup" form at a time. The user will enter the data and click the "Print Report" button again. Now, the macro should check the fields again, giving the apropriate "popup" form, (and so on). If no missing data, a report is printed.
I don't know if this can be done, but please advise.
I have been working on an Access database that has several tabs with each tab having several controls/fields. Some of these controls/fields are to be "required" for data entry (but not using required attribute in the table). Also, on the form there is a command button for users to click to print a report using data from all controls.
Now, when users click the "Print Report" button, I want the database to check if the "required" fields have data in them. If not, another form opens and asks the user if they want to enter the missing data for that particular field or cancel the entire report and close database. When a user clicks continue, the "popup" form closes and focus is sent to the field with the missing data. However, here is the problem. The macro I have running to check the fields generates several "popup" forms for each field missing data, all at the same time. I would like the macro to generate only one "popup" form at a time. The user will enter the data and click the "Print Report" button again. Now, the macro should check the fields again, giving the apropriate "popup" form, (and so on). If no missing data, a report is printed.
I don't know if this can be done, but please advise.