"Property Not Found" Error on BeforeUpdate Cancel

Discussion in 'Access Forms Coding' started by saztronic@gmail.com, Aug 28, 2008.

  1. Guest

    I'm trying to use the BeforeUpdate Event in Access 2007 to potentially
    cancel a combobox selection. The combobox is bound, and located on a
    subform displaying in datasheet view. The code can be as simple as


    Combobox_BeforeUpdate (Cancel As Integer)

    If MsgBox("Sure?",vbYesNo) = vbNo Then
    Cancel = True
    End If

    End Sub


    Presumably, if the update is canceled the combobox should revert to
    its previous value. Instead, the code steps through nicely but once
    End Sub is reached a box pops up with the error message "Property Not
    Found", and the update is not actually cancelled.

    I've googled this and seen others with the same problem who had it
    working previously in Access 2003, but then started getting this weird
    error once they updated to 2007. I've not seen any answer that
    explains the phenomenon or what to do about it.

    Any suggestions?

    , Aug 28, 2008
    1. Advertisements

  2. Maverick Guest

    Try something more simple. With a combobox named cboCombo, then use the
    following code:

    Maverick, Aug 28, 2008
    1. Advertisements

  3. phenix

    Apr 29, 2013
    Likes Received:
    This is a buggie in MS Access 2007, what you need to do is either use Docmd.CancelEvent or use undo in AfterUpdate event. Below is the link to do it.
    phenix, Apr 29, 2013
    1. Advertisements

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.