Parameter Query

[Susan Jayne]

Hi hope you can help - I have created a parameter query to display all the data for one Company.

The parameter query asks you to "Type Company Name".

Seemed simple enough to me but my users are used to calling the Company by its short name ie Taylor Building instead of the full name Taylor Building Company Limited, and the full name is in the Table. Therefore the query is coming back with no data.

Is there any way I can have the parameter query display a list of company names for the user to choose from, rather than prompting them to type in the name?

Thanks for your help.

Susan

 

[Tommy B]

Hi Susan,

Got a couple of thoughts on this..you could put the following in your select query : Like [Enter Company Name]* this will tag a wild card to the variable if they are shortening the name. Or for a more robust solution:

Create a form with a combo box that feeds from a table, lets call it client name. Then in your query put [Form]![Form Name]![Client Name] where client name is the name of your combo box. Now the query will look at the name selected in the combo box.

Hope this helps,

Tommy B

[This message has been edited by Tommy B (edited 10-04-2001).]

 

[Susan Jayne]

Hi Tommy

Sorry to be so long acknowledging your reply - I've been on hols! -

Thanks very much for your help, the problem is now solved, cheers

Susan