Hi,

Im building a little app in VB.net to help me on my daily job, where i use some combo boxes to record some value to access.
But i don´t know how to get the last ID(Automatic Number) to a msgbox.

My code:

Simple 2 comboBox´s insert value to 2 columns pressing one button, but after that i want a msgbox to say the last recorded value from ID

provider = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source="
datafile = "C:\Users\RR\Documents\Database2.mdb"
connString = provider & datafile
myConnection.ConnectionString = connString
myConnection.Open()
Dim str As String
str = "Insert into Guias([Remetente],[Destinatário]) Values (?,?)"
Dim cmd As OleDbCommand = New OleDbCommand(str, myConnection)
cmd.Parameters.Add(New OleDbParameter("Remetente", CType(ComboBox1.Text, String)))
cmd.Parameters.Add(New OleDbParameter("Destinatário", CType(ComboBox2.Text, String)))
Sorry guys im trying to learning VB.net