i am trying to insert a last ID from the prev query into another table. i think i&#039;m almost there, but getting an error at this line:<BR> insertComm.Parameters.Add( "@lastID", lastID.Integer)<BR>and not sure how to handle it.<BR><BR> &#039; select last ID entered<BR> Dim maxSQL As String = "SELECT max(ID) as lastID FROM users"<BR> Dim maxComm As New OleDbCommand(maxSQL, conn)<BR> <BR> &#039; insert that ID into the homes table<BR> Dim insertSQL As String = "INSERT INTO [homes] ([user_id]) VALUES (@lastID)"<BR> Dim insertComm As New OleDbCommand(insertSQL, conn)<BR> insertComm.Parameters.Add( "@lastID", lastID.Integer)