dialog box/parameter query

  • Thread starter Thread starter adker
  • Start date Start date
A

adker

I'm using a list box to create the parameter for a query and whatever I name
my text box, I get a request to reenter the parameter when I run the query.
The query always runs fine but I can't understand why I have to enter the
parameter twice. When i create the query I use the expression maker and copy
directly from the dialog box to insert the parameter in the query. Any
suggestions will be very much appreciated.
 
I'm using a list box to create the parameter for a query and whatever I name
my text box, I get a request to reenter the parameter when I run the query.
The query always runs fine but I can't understand why I have to enter the
parameter twice. When i create the query I use the expression maker and copy
directly from the dialog box to insert the parameter in the query. Any
suggestions will be very much appreciated.
Click to expand...

Are you using

[Forms]![NameOfTheForm]![NameOfTheControl]

as your parameter? It won't work otherwise.

Please post the SQL view of your query, and the name of your form and control,
if this isn't helping.
 
John W. Vinson said:
I'm using a list box to create the parameter for a query and whatever I name
my text box, I get a request to reenter the parameter when I run the query.
The query always runs fine but I can't understand why I have to enter the
parameter twice. When i create the query I use the expression maker and copy
directly from the dialog box to insert the parameter in the query. Any
suggestions will be very much appreciated.
Click to expand...

Are you using

[Forms]![NameOfTheForm]![NameOfTheControl]

as your parameter? It won't work otherwise.

Please post the SQL view of your query, and the name of your form and control,
if this isn't helping.
Click to expand...
 
Back
Top