how to check duplicate in form view insert Before inserting in MS ACCESS RRS feed

  • Question

  • User1557055387 posted
    I want to Check Gr #(PK) of student wheter exist in table or not id exist show Msg in Label after lost focus from text box ..
     I tried AutoNumber in Access but it showing error while insertion 
    Note : im using form View control for insertion...
    please help A S A P


    Saturday, August 21, 2010 4:17 PM


  • User-821857111 posted

    If you are using Autonumbers, you shouldn't be trying to insert anything in to the PK. Access takes care of generating that for you. Remove anything that tries to add a PK value. That's what causes the error in all probability.

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Saturday, August 21, 2010 4:55 PM