Query Parameters???

[cannan]

I have a database with thousands of company names. I want to be able to start typing the company name in the parameter box and have options come up as I type. For example if I wanted the company Chance. I could start typing the name and Chance would automatically appear in the parameter box and all I would have to do is hit enter once the name was there in the parameter box. Is this possible??...and how would I go about doing this.

 

[Rich]

Use a pop up form with a combo box based on the company name table, set the criteria to the form and combo
ie Forms!SomeForm!SomeCombo

 

[cannan]

I need a little more information than that. I understand what your trying to say. I just cant seem to get the expression right, any examples or more help would be greatly appreciated.

 

[krisleech]

combo box

you need to make a new form, and drag and drop all the field onto the form that you wish to use. (or create an autoform).
then delete the input box for company name and replace it with a combo box. If you have wizards installed and clicked to on, the combo box wizard should appear and guide you though creating the combo box. The source for the combo box should be the company name field.
thats it. When u open the form and start to type into the combo box it should complete the input for you or of course you select your compnay name from the combo box as normal.

hope this helps.

Kris Leech