No, I do a .Parameters.Refresh -->
With adoCommand
adoCommand.CommandText = "sp_InsertAirMaster"
adoCommand.Parameters.Refresh
adoCommand.Parameters(1) = mskMAWBAir.Text
adoCommand.Parameters(2) = 2
(...)
adoCommand.Parameters(16) = txtComments.Text

Set adoRecord = adoCommand.Execute

MsgBox adoRecord!PK_MasterID --> ERROR
End With

Here is my stored proc-->


CREATE PROCEDURE sp_InsertAirMaster
@Master nvarchar(20),
...
AS
INSERT INTO tblMasterAir
(tblMasterAirwaybill.MAWB
...)
VALUES
(@Master,
...)
SELECT PK_MasterID FROM tblMaster WHERE PK_MasterID = @@Identity

-->
The stored proc work well in query analyser but fail in VB...


Help...
Patrice Merineau