ADO 2.5 INSERT Statement (VB6)

Folks
I'm running an insert statement into an Access database using ADO 2.5. What I want to know is can I return values if I use the Connection classes Execute statement. For example:

I have a table, Jobs, consisting of these fields:

JobID - AutoNum, primary key
Description - Text
JobDate - Date/Time

and I want to do the following*

sqlString = "INSERT INTO Jobs (Description, JobDate) " 
sqlstring = SQLSTRING & "VALUES ('BLAH', SOMEDATE)"

with objConnection
    .BeginTrans
    .Execute sqlString '// This is the bit I'm interested in
    .CommitTrans
end with

When I execute the insert statment is there anyway I can get the value of the WorkItemID field returned from the Execute method? At present it returns a closed recordset which is no use to me.

I know I could use the AddNew method on a recordset to achieve these results, but I was just wondering.


*Example code only, probably full of errors