AddNew

Hi All:
I am stuck and need your guys help again! Here is what I need to do. After adding a new row in my table,how can I get the id of the new row? I though using the Max function and looked into requery method as well,however both of these functions did not work. My table is a sql table that automatically increases the id pointer to the next higher number.

Thansk:ehh:

This thread would get better feedback if you posted a link to it in
the Databases Forum.

The Max function should work, but depends on how your
application's access method to the db.

HTH

Thanks, I will try and let you the outcome.