I think I am going about this all wrong. I am developing in a data project(.adp). Do I still need to create a connection in order to return...

Dim cmdSQL As ADODB.Command

Set cmdSQL = New ADODB.Command

cmdSQL.CommandText = "select count(OrderQty) from RFQOrderQtys where RFQNumber = " & Me.RFQNumber

cmdSQL.CommandType = adCmdText

Dim rsSQL As ADODB.Recordset

Set rsSQL = New ADODB.Recordset

rsSQL.Open cmdSQL

Dim intCount...

Thanks. I will keep OUTPUT in mind for my next project. It does look promising.

Works GREAT. Thank you very much!

This could work for me. How do I make a variable equal to SCOPE_IDENTITY()? The variable needs to be an integer. Is it as easy as: ...