Query Access Table for Autonumber Value RRS feed

  • Question

  • I am using an access database for the back-end of my application and using a auto-number field to generate the uniqueID value.

    Is there a way, on save, to query and retrieve the value the access database is assigning so my users can then enter data into a sub table on the same form.


    I have txtbx_SystemID.Text displaying an autonumber for SystemID. When adding a new record I want the user to save the record and retrieve that value so they may enter into a datagridview associated records that will link by that systemid.

    Tuesday, June 27, 2017 2:56 PM


All replies