Making attachment mandatory without generating VB debugs

[srivatsan]

Hi,


Can someone help me how to make attachments mandatory in MS Access form. when i make attachment mandatory in table field it creates VB debug in form if the users bypass without attachments to go to the next record.
I prefer to control fields at form level as the end users have no access to the tables and queries. they can only use options through switchboard.
I am using MS Access 2013 version. I'm not an expert in VB. So, many options that used to be in 2000-2003 version are no longer available in the latest versions.
Thanks in advance for your support.
Good regards
Srivatsan

[June7]

Most experienced developers recommend against embedding objects in table as this adds complications (as you are experiencing) and uses Access file size limit. Alternative is a text field that saves file path string.

Otherwise, use form BeforeUpdate event to validate data. However, I am striking out on code that can verify content of control bound to attachment field. It is possible to verify content of field with DLookup() but that would require first committing record to table which hasn't yet happened.

[rkeifer]

What is the error number and description you receive.