report parameters

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

klr397 - 13 Dec 2005 17:29 GMT

I have a report which has a paremters box which has you type in the name of
the customer and then it comes up with all the job orders that customer has
ever had with my company. however spelling seems tobe a major problem. Does
anyone know how or even if I could have a drop down list with the names of
all the companies instead of having to type it in?

Reply to this Message

Rick B - 13 Dec 2005 17:46 GMT

Yes. Create a separate unbound form. Ad one combo-box to the form and set
the source to pull all the valid names. Let the user select the entry from
there. In your query, point to that form for your criteria...

=Forms![MyFormName]![MyFieldName]

Signature

Rick B

>I have a report which has a paremters box which has you type in the name of
> the customer and then it comes up with all the job orders that customer
[quoted text clipped - 3 lines]
> anyone know how or even if I could have a drop down list with the names of
> all the companies instead of having to type it in?

Reply to this Message

klr397 - 13 Dec 2005 18:27 GMT

It's still pulling up my old peramiters but i deleted themwhat should be in
the my field names part? the name of the combo box or the neame of what goes
in the combo box?

thanks

>Yes. Create a separate unbound form. Ad one combo-box to the form and set
>the source to pull all the valid names. Let the user select the entry from
[quoted text clipped - 7 lines]
>> anyone know how or even if I could have a drop down list with the names of
>> all the companies instead of having to type it in?

Signature

Please Help me 8-)

Reply to this Message

Rick B - 13 Dec 2005 20:32 GMT

In your query, your field names would not change at all, only the CRITERIA.
Instead of having criteria like...

Like "*" & [Enter Name To Pull] & "*"

you would use...

=Forms![MyFormName]![MyFieldName]

Signature

Rick B

> It's still pulling up my old peramiters but i deleted themwhat should be
> in
[quoted text clipped - 19 lines]
>>> of
>>> all the companies instead of having to type it in?

Reply to this Message

fredg - 13 Dec 2005 18:23 GMT

> I have a report which has a paremters box which has you type in the name of
> the customer and then it comes up with all the job orders that customer has
> ever had with my company. however spelling seems tobe a major problem. Does
> anyone know how or even if I could have a drop down list with the names of
> all the companies instead of having to type it in?

Answered elsewhere.
Please do not multi-post. If you feel you must post the same question
to more than one newsgroup (and it's seldom necessary), cross-post by
adding each additional newsgroup in the To Newsgroups: box, separated
by a comma.
This way an answer in one newsgroup will be seen in each of the
others. More readers will see the response and learn, and less time
will be spent on duplicate answers.

See Netiquette at http://www.mvps.org/access

It's a great site to visit anyway.

Signature

Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail

Reply to this Message