strange parameter query

[hi there]

hey all,

i created a parameter query based on text box inputs from a form. specifically i'm using a Between [] And[] statement in my query. when i run the query by clicking on the icon (in the queries tab) it prompts me for the inputs and runs fine, but when i try to run it by filling in the inputs on the form it doesn't work. can someone tell me what i'm doing wrong? i'm using access 97.

thanks

 

[Rich]

You haven't set the form references correctly, use the code builder to get the full syntax

 

[hi there]

i used the code builder to build the parameter expression, but it still doesn't work. i'm not sure what the problem is because the input parameter prompts (1st and 2nd) that appear when i run the query from the query tab (not the form) list the proper reference to the form's text boxes and works fine. i'm stumped.

thanks for the reply rich any more ideas?

 

[raskew]

Post your code.