Your article is very helpful.

What I wanted to know is if I can get a return value from the procedure. Basically what I need to do is enter data in one table, get the autonumber value it returns and enter it into another table, all in the same procedure. Is this possible ? All my searches turned out to be for ADP which is Access connected to SQL server. This is not what I need. I also came accross @ReturnValue, but that did not seem to work.

Please let me know if you have an idea.

Many thanks in advance.

Tomarsh

Unlike SQL server, Access does not implement output variables, so an Insert procedure/query cannot return the value of a newly created autoinc key field, for example.
However, there is a way to retrieve this value, by executing a 2nd command to the ADO engine:
"SELECT @@IDENTITY"
will return the key value of the last record inserted, regardless of the table being used. (so make sure you call it right behind the Insert call)

That's it.

Unlike SQL server, Access does not implement output variables, so an Insert procedure/query cannot return the value of a newly created autoinc key field, for example.
However, there is a way to retrieve this value, by executing a 2nd command to the ADO engine:
"SELECT @@IDENTITY"
will return the key value of the last record inserted, regardless of the table being used. (so make sure you call it right behind the Insert call)

That's it.