From Access it would be something like this:cmd.CommandText = MyStoredProcdim parm as New ADODB.Parameterset parm = cmd.CreateParameter(LocID, adInteger)cmd.Parameters.Append parmcmd.Parameters(LocID) = [Forms]![aform]![loc]Set rs = cmd.Execute()I would recommend NOT using some sort of table to hold the current location.