Using a value from a control property in a Subquery

[thefarg]

I have a combobox. It has "A" as the value in the .Tag property.
As the rowsource I have a list of values in a table. I want to set the controlsource to a single record in a table, simular to
dlookup ("Column", "Table", "Row =" & Variable).
I am trying to set the controlsource to
[SELECT tblIdentifiers.[Identifier Name] FROM tblIdentifiers WHERE (tblIdentifiers.[Identifier Letter] = Me.Activecontrol.Tag)]
but am unsure about using a variable or property in an SQL statement.
Any help much appreciated
Mike

 

[Andrzejek]

Have you tried:
[tt]
strSQL = "SELECT tblIdentifiers.[Identifier Name] FROM tblIdentifiers WHERE (tblIdentifiers.[Identifier Letter] = '" & Me.Activecontrol.Tag & "')"
[/tt]


Have fun.

---- Andy