Expression Builder - Should work but it's not ?

[ardy]

Hello All.....
This should work but I get #Name? instead of the first name.....I am using this in a form. trying to pull the student name from a field in the form that has the student ID.
---------------------------------Expression----------------------------
="SELECT [Student_Profile]![First_Name] FROM [Student_Profile] WHERE [Student_Profile]![Student_ID]=" & [Me].[Student_ID] & ";"
-----------------------------------------------------------------------
I wonder why ?

ardy

 

[pbaldy]

You can't use SQL in a control source like that. Try a DLookup(). This may be an alternative:

http://www.baldyweb.com/Autofill.htm

 

[ardy]

Thanks........ I will give that a try.......

 

[pbaldy]

No problem; send garlic.