Recent content by stephen.regina.rains

One more suggestion. Try trapping the error and ignore the redundant ones. Example: On error goto Err_FormBeforeUpdate ... Exit_FormBeforeUpdate: Exit sub Err_FormBeforeUpdate: Select case err.number case xxxx resume next ... End Select Exit Sub

The error handling in code handles visual basic error codes, but as I recall data errors have to be handled separately by trapping the data error event. If you are just validating that required fields are filled in, it may be easier to set the required property of the table fields to yes.

I created some HTML help pages for a database, created command buttons on forms with code to follow the hyperlink property. When I open Access 2003 and then open the database with shift held (design mode) and click on the command buttons, the help page open properly, but if I open the database...