How to Look up a form using a Combo Box

[smc678]

I have a form that is connected to a Table. I need to be able to select a name from the combo box on the form and it will goto the specfic record. I do not wan to add records as this is associate profile information.

[orange]

See this site for a number of tutorials related to combo boxes
http://www.techonthenet.com/access/comboboxes/

If you don't see what you need, try youtube and search for MS access comboboxes

[Missinglinq]

Here's a short tutorial:

• Add a Combobox to your Form.
• The Combobox Wizard will pop up
• Select "Find a record based on the value I selected in my combobox."
• From the Table or Query the Form is based on, click on the Field you're searching by (a Field that is unique for each Record) to move it to the right side.
• Hit Next.
• Size the column appropriately.
• Hit Next.
• Name the Combobox something appropriate.
• Hit Finish.
  
  

Now you can drop the Combobox down and scroll down to the item to search by, or you can start to enter the item, and the Combobox will "autofill" as you type. Hit <Enter> and the Record will be retrieved.

Linq ;0)>