Bound control, autonumber, rejectchanges

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • Maurice Mertens

    Bound control, autonumber, rejectchanges

    Hi,

    I'm having a form with a bound control "ID" and it's bound to an Access
    database. The field ID is an autonumbering field.

    When I add a new record, the ID is numbered 1 up, for example from 10 to
    11. When I cancel this update, ds.rejectchange s, i return to record with ID
    10. When I now add a new record again, the ID is 12. But when I save the
    record and recall it, the ID is 11.

    Can anyone help me with this problem? The user first sees ID 12 but after
    saving the record it gets a new ID, 11. This is not very nice.

    --
    Met vriendelijke groet / With regards / Saludos,
    Moviat Automatisering


    Maurice Mertens
    mauricem@moviat _KillSpamWordFo rEMail.nl

    tel: +31 162 470 534
    fax: +31 162 470 502
Working...