Parameter Dropdown Text Box..

[stephendeloach via AccessMonster.com]

I have a report that when I open it, I am asked for Date and Rig Name. How
can I make another Box pop up and have two choices of who I want it to be
billed to and when I select one of the choices it be put in the Bill To: box
in my report? Thanks for the help...

 

[Allen Browne]

Sounds like you are using the parameter dialog that pops up and says:
Enter parameter value
That is not powerful enough to have drop-down lists.

Instead, create a form. Open it before your report, and have the query read
the values from the form.

There's a couple of ways to do this. See:
Limiting a Report to a Date Range
at:
http://allenbrowne.com/casu-08.html

Method 2 in that example uses text boxes for the dates, but it's exactly the
same for combo boxes on your form.

You can have the query read the combo value in your form by entering
something like this in the Criteria row of your query:
[Forms].[Form1].[Combo7]

Alternatively you can build the WhereCondition string to filter the report.

 

[stephendeloach via AccessMonster.com]

yeah I already have that for the date. What I am needing is a box that pops
up and dosent run a query (I quess?), It just enters the address I want into
the Bill To box on the report... I have 2 addresses i am going to be billing,
TSWS with the address directly below it, and WHS with the address directly
below it. I cant get it to display the address below them in the Report... If
I change the Bill To field in the Drilling Form to just TSWS it comes up fine.
But when it is the whole address it says #error... If that helps... Any
suggestions? Thanks for your help..

Sounds like you are using the parameter dialog that pops up and says:
Enter parameter value
That is not powerful enough to have drop-down lists.

Instead, create a form. Open it before your report, and have the query read
the values from the form.

There's a couple of ways to do this. See:
Limiting a Report to a Date Range
at:
http://allenbrowne.com/casu-08.html

Method 2 in that example uses text boxes for the dates, but it's exactly the
same for combo boxes on your form.

You can have the query read the combo value in your form by entering
something like this in the Criteria row of your query:
[Forms].[Form1].[Combo7]

Alternatively you can build the WhereCondition string to filter the report.

I have a report that when I open it, I am asked for Date and Rig Name. How
can I make another Box pop up and have two choices of who I want it to be
billed to and when I select one of the choices it be put in the Bill To:
box
in my report? Thanks for the help...

 

[Allen Browne]

Sorry: I didn't really follow that.

Perhaps you could look at the Northwind sample database, and see how the
shipping address is handled on the Orders form. It defaults to the
customer's address when you pick a customer, but you can overwrite it and
store a different address if needed. The form then remembers that address,
and prints it on the order.

If that's of no use, I have not understood what you are seeking to do.

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

yeah I already have that for the date. What I am needing is a box that
pops
up and dosent run a query (I quess?), It just enters the address I want
into
the Bill To box on the report... I have 2 addresses i am going to be
billing,
TSWS with the address directly below it, and WHS with the address directly
below it. I cant get it to display the address below them in the Report...
If
I change the Bill To field in the Drilling Form to just TSWS it comes up
fine.
But when it is the whole address it says #error... If that helps... Any
suggestions? Thanks for your help..

Sounds like you are using the parameter dialog that pops up and says:
Enter parameter value
That is not powerful enough to have drop-down lists.

Instead, create a form. Open it before your report, and have the query
read
the values from the form.

There's a couple of ways to do this. See:
Limiting a Report to a Date Range
at:
http://allenbrowne.com/casu-08.html

Method 2 in that example uses text boxes for the dates, but it's exactly
the
same for combo boxes on your form.

You can have the query read the combo value in your form by entering
something like this in the Criteria row of your query:
[Forms].[Form1].[Combo7]

Alternatively you can build the WhereCondition string to filter the
report.

I have a report that when I open it, I am asked for Date and Rig Name.
How
can I make another Box pop up and have two choices of who I want it to
be
billed to and when I select one of the choices it be put in the Bill To:
box
in my report? Thanks for the help...