Is the following possible? If so, I'm doing correctly.

already have DB Connection done...

strSQL = "Select type FROM UserRights WHERE username = " & txtusername.text &" AND DBTab = " & txtDBTab.text & ""

Now the type from SQL statement returns, I want to return this value back to the Calling Functiion.

i.e. Return Type

Any help is appricated, Thanks,
Mark

Use recordset / dataset to access data as the result of query.


Gokulan Ethiraj