How do I go to a specific record?

[gundie]

I have a table with company admin data (company name, address, phone...) bound to a form. Within the form, I also have a combo box with a list of company names in the table. I want to be able to:

1. Pull up any company by using the combo box, and
2. Search for a company by using CTRL-F within the company name field

Without #2, I can simply create a query that pulls the desire company from the combo box selection, but if a query is used, I lose the CTRL-F functionality because the query only return 1 specific record.

Question: how can I tell the form to go to a specific record without the use of a query?

(Hope I'm making sense here...) TIA!

 

[Remou]

If you create the combobox using the wizard, it will offer this as an option.

 

[missinglinq]

Here's a step-by-step:

Place a combo box on the form. When the Combobox Wizard comes up:

Select "Find a record on my form based on the value I've selected..."
Next
Select the appropriate identifying field to appear in the Combo box
Next
Size the Combo box column
Next
Name the combo box
Finish

Now the user can use the dropdown arrow of the combo box to retrieve the data or simply start typing the identifying data in and the combo box will start to autocomplete the entry. When the correct entry is found hit <Enter> and the appropriate data should be retrieved.

The Missinglinq

Richmond, Virginia

There's ALWAYS more than one way to skin a cat!