Receiving a paramater value box???

  • Thread starter Thread starter Joseph Atie
  • Start date Start date
J

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));
 
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));
Click to expand...

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.
 
Back
Top