Search Box that auto-populates

[LukeJ Innov]

Hello All,

I am trying to create a search box on a form so that when something is searched and selected it auto populates textboxes on the form.
For instance:
I have a table called contacts, it houses data on contact name, work department, phone numbers etc. I have a form that allows the user to view the contact data, but how would I implement a search control so the user can search for something and it pulls the data from the table and plugs it in to the form fields.
I have tried using a combo box, but all I can get it to do is simply display values.

Thanks in advance,



Regards
LJ

[pradeep.sands]

Hi,
Like you said you have contactname, wrkdept, phnum fields. And you have 3 text boxes (names txtbox1,txtbox2,txtbox3) to display these three field values.
Like you said, when you search for something, is your result stored as a query or recordset? If so, then you can simply write this code:
txtbox1 = Me.Fields(1).Value
txtbox2 = Me.Fields(2).Value
txtbox3 = Me.Fields(3).Value

[Missinglinq]

Here's a step-by-step for using a Combobox to retrieve an existing Record:

Create a Form based on your Table, including all the Fields you want displayed.

Then simply:

• 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 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)>

[LukeJ Innov]

Many many thanks Missinglinq.

I think the problem was that my form was not created based on a table, I had a blank form in which I had dragged fields onto it, and the option in the wizard was not their.
Regards
LJ