Set Variable to Query Field

[Dorci]

In Access code, how do I set a variable equal to a query field. I'm trying
to do this:

Dim strProjectNumber As String
strProjectNumber = (Select ProjectNumber from tblProjNums where ID = C

I'm getting an "expected expression" error. I get the impression I somehow
need to tell it that I'm trying to run a SQL Select statement.

Thanks for you help.
-Dorci

 

[Allen Browne]

Use DLookup():
strProjectNumber = Nz(DLookup("ProjectNumber", "tblProjNums", _
"ID = 'C'"), vbNullString)

For an explanation on DLookup() see:
Getting a value from a table: DLookup()
at:
http://allenbrowne.com/casu-07.html

 

[Dorci]

PERFECT! You're a life saver. Thanks so much!

Use DLookup():
strProjectNumber = Nz(DLookup("ProjectNumber", "tblProjNums", _
"ID = 'C'"), vbNullString)

For an explanation on DLookup() see:
Getting a value from a table: DLookup()
at:
http://allenbrowne.com/casu-07.html