DAO and key number.

[sal21]

this is an old project...

In a table1 have a key autonumber named ID.

now i add new set of fields with:

rs.addnew
...
rs.update

but after update, and without a query, is possible to know the number of new ID key number and add the value in MYVar?

[HansV]

The new AutoNumber value is available when you execute AddNew:

Code: Select all

    rs.AddNew
    MyVar = rs.ID
    ...
    rs.Update

[sal21]

The new AutoNumber value is available when you execute AddNew:

Code: Select all

    rs.AddNew
    MyVar = rs.ID
    ...
    rs.Update

work! buit i have changed rs.ID in rs!ID.

with rs.ID, i have error

[HansV]

Yes, that's better.