report parameters

  • Thread starter Thread starter klr397
  • Start date Start date
K

klr397

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?
 
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]
 
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?
Click to expand...

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.
 
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

Rick said:
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]
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
Click to expand...
[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?
Click to expand...
Click to expand...
 
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]

--
Rick B



klr397 said:
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

Rick said:
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]
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
Click to expand...
[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?
Click to expand...
Click to expand...
Click to expand...
 
Back
Top