Moving select query result to variable

[jasmine03]

How can I get the value of a select query into a variable? For example, the result of this query "Select ID from table A" should be moved into variable X.
Also what is the syntax to write a sub-query. I tried the following and it does not seem to work.
"Select NAME from Table A where ID=( "Select AID from table B where SName like 'ABC' ")"

[Craig Gemmill]

We need more details from you on this one.

Is this in an ADO.NET environment?

OLE/SQL?

Can you post the context of this code?

[jasmine03]

I use the OleDB connection to connect to the Access database which has 3 tables. The following is the code I have. I am trying to populate combo boxes with data from the tables. One of the combo box data needs to be displayed based on the previous combo box selection which is in a different table.

In line 4 below, I am trying to get the result of the select command into variable temp and in line 5 (which is not complete) I want to use the value of temp to get the fid. I want to either do this way or be able to use a subquery.

Private Sub cmbForms_SelectedIndexChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles cmbForms.SelectedIndexChanged
1) DsAddendum1.Clear()
2) Dim temp As String
3) Dim paramval As String
4) temp = "Select fid from FG where fg.forms '" &cmbForms.SelectedItem.Row.ItemArray(0) & "'"
5) paramval = "Select addendum from addendum where fid=( " & temp )
6) daAddendum.SelectCommand.CommandText = temp
7) daAddendum.Fill(DsAddendum1)
End Sub