Dialog box - paramater query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello all.

I have a Dialog Box to set parameters for two fields: one is "supplier" and
the other is «between [StartDate] and [EndDate]. The "supplier" parameter is
working OK, but the dates parameter NOT.

The query is base on two other queries which are based on two and one
queries, respectively. I have set the criteria parameter entries in the
"base" queries, i.e., in these last two+one queries, because they're the ones
that contain the fields "StartDate" and "EndDate". It's not working.

Two questions:
1) Must the criteria parameter entries be set in the "last" query?
2) I have three dates, three different fields, in the "base" queries, and I
want to entry only one parameter to set the (same) date for these three
fields. Is that possible like this?

Thank you.
 
Francisco

I am somewhat confused, and am not visualizing your situation well.

What happens if you only consider your "first-in-the-chain" query? Does it
work properly with the values in your dialog box?

Is your "dialog box" actually a form, or something else?

How does your first query get it's parameters? Does it work properly?

Then I'd step to the "next-in-the-chain" and test it the same way.
 
Jeff,

To your questions: the dialog box is a form, with a combo box and two text
boxes. Thanks for the hints, they are valueble for the future, but I found
the problem, it was just a misspelling of the parameters. Now it's working
correctly as planned. Thank you.

Jeff Boyce said:
Francisco

I am somewhat confused, and am not visualizing your situation well.

What happens if you only consider your "first-in-the-chain" query? Does it
work properly with the values in your dialog box?

Is your "dialog box" actually a form, or something else?

How does your first query get it's parameters? Does it work properly?

Then I'd step to the "next-in-the-chain" and test it the same way.

--
Good luck

Jeff Boyce
<Access MVP>

Francisco F. said:
Hello all.

I have a Dialog Box to set parameters for two fields: one is "supplier" and
the other is «between [StartDate] and [EndDate]. The "supplier" parameter is
working OK, but the dates parameter NOT.

The query is base on two other queries which are based on two and one
queries, respectively. I have set the criteria parameter entries in the
"base" queries, i.e., in these last two+one queries, because they're the ones
that contain the fields "StartDate" and "EndDate". It's not working.

Two questions:
1) Must the criteria parameter entries be set in the "last" query?
2) I have three dates, three different fields, in the "base" queries, and I
want to entry only one parameter to set the (same) date for these three
fields. Is that possible like this?

Thank you.
Click to expand...
Click to expand...
 
Back
Top