dialog box/parameter query

[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.

 

[John W. Vinson]

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.

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.

 

[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.

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.