Limitations on number of queries looking at a form text box for parameters?

[accessaspire219]

I have a database with a number queries containing monthly performance data for each person. I use a form to specify the criteria such as Name of the person, role of the person and the period and have prompts in the queries which look at the form for this criteria. (all these queries look at the same text boxes) This worked fine for the first two queries but when I tried to use the same for a third query it returns no results as if it did not pick the criteria from the form. I tried to run the query (bypassing the form) and entered the parameters manually at the prompts and it works fine. Does anyone know if there is a limitation on how many queries can look at a form field for parameters?

 

[Kryst51]

hmmm, i am no expert, but I doubt that that is the problem. Can you post your db or some sort of example? I have never experienced anything like that; I bet something else is going on.

 

[accessaspire219]

I sorted it out. It was an issue with the way I was calling the query from the form. Thanks Kryst51 for your response.

 

[Kryst51]

Your Welcome. I am glad that you got it figured out.