Get last ID

[spinkung]

Me again...

I've been looking on the forums for a way in which to get the last id in a table using sql statements in vba but i'm not sure what i should be looking for.

I first add the new entry to a table. I then want to grab that exact number and use it in an update query.

is there a way????


there are too many people using it to use max on the id field.

Many thanks

 

[pbaldy]

Search here on @@Identity. If you use the appropriate method to add the new record, you can use it to get the correct ID.

 

[spinkung]

Thanks,

This is the answer....
http://www.access-programmers.co.uk/forums/showthread.php?t=165627&highlight=%40%40Identity