Anthony Niemann
|
| Posted: 04/08/2002, 10:19 AM |
|
I want to open the same record for update immediately following insert.
I added the following code to the "AfterInsert" event but it doesn't work.
I'm starting to flail madly, any help would be appreciated. The key field is
ClassID.
openrs IdentityRS, "SELECT @@IDENTITY AS RecordID"
sParams = sParams & "?ClassID=" & cstr(GetValue(IdentityRS, "RecordID")) &
"&"
Set IdentityRS = Nothing
Thanks, Tony
|
|
|
 |
Anthony Niemann
|
| Posted: 04/08/2002, 3:50 PM |
|
Never mind, I got the following to work.
AfterInsert:
openrs IdentityRS, "SELECT @@IDENTITY AS RecordID"
sActionFileName = sActionFileName & "?ClassID=" & cstr(GetValue(IdentityRS,
"RecordID")) & "&"
Set IdentityRS = Nothing
Thanks.
|
|
|
|
|
