Receiving a paramater value box???

[Joseph Atie]

basicly i want it to lookup the where value from a field
in a form, but instead it keeps prompting me for the
paramater value with a popup box

SELECT [trasmital drawings].[DWG No] FROM [trasmital
drawings] WHERE ((([trasmital drawings].[Project Code])
=Me!Project_Combo));

 

[John Vinson]

basicly i want it to lookup the where value from a field
in a form, but instead it keeps prompting me for the
paramater value with a popup box

SELECT [trasmital drawings].[DWG No] FROM [trasmital
drawings] WHERE ((([trasmital drawings].[Project Code])
=Me!Project_Combo));

Name the form explicitly, Forms!formname, rather than using the Me!
syntax. The form must be open of course.

Me! is usable in VBA code, but the SQL query engine doesn't have a
clue which form you mean.