Go to Top

Bug will occur when using datasheet view in a sub form.

Here’s a bug you will come across when using a subform in datasheet view:

“Property Not Found”

ADVERTISING
ACCESS SAFETY AND TRAINING DATABASE

Here is the code that will trigger the criptic message from Access:

Private Sub MyField_BeforeUpdate(Cancel as Integer)

if somecondition = True then

Msgbox “Your message here, usually you can’t save the record because of something”

Cancel = True

end if

End Sub

To fix the issue, replace Cancel = True with:

DoCmd.CancelEvent

About Juan Soto

Juan Soto is a Senior Access Developer at IT Impact Inc. and a Microsoft Access MVP. He specializes in Access with SQL Server databases. His passion for Access has led him to helping a wide range of businesses in helping them establish a secure, stable and efficient environment with SQL Server. He's a frequent speaker at Access user groups nationwide and recently spoke at the Orange County SQL Saturday # 73. If you wish to have Juan speak at your next group meeting you can contact him here.

Leave a Reply

Your email address will not be published. Required fields are marked *

 

Contact Us
[gravityform id="16" title="false" description="false"]