Does anyone know how through a sql statement to get the next number from a autonumber field in MSAccess.

I have two statements, (1st)one that inserts data into the autonumber table and (2nd) another statement that fills data in another table. The second statement must run before the first and i need the value of the autonumber for the second statement.

Any help would be grateful