Apr 8 2011, 01:57 PM
I have a form with a drop down box, when something is selected from the box I have a requery event occur in the AfterUpdate event to refresh data in a subform. However, whenever this event occurs I am getting a Run Time error 3314 saying you must enter a valued in the [date field]. There are other fields that a user needs to fill in after the drop down box, and each of these fields is required in the table.
Apr 8 2011, 02:00 PM
I would imagine that you need to change the way you verify the data
In your table you would remove/change the Required option to NO
Then on your Form you would have some VBA to prompt the user for data to be entered in the required fields on Close of the Form
Apr 9 2011, 10:05 AM
Actually this kind of validation really should be done in the Form_BeforeUpdate event.
I'm unclear as to why you need to Requery the subform simply because you've added a piece of data to the current record.
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here