Access table search from form

[Solid]

Ok ill make this easy. lets say I have to tables "users" "computers" and they are related. Now I have a form where I want to be able to type a userID in a textbox and click a button and it will search the "users" table for the userID and populate the form (which has other textboxes) with information that corresponds to that userID from both tables.

I cannot for the life of me remember how to code this. Any help would be awesome.

[missinglinq]

First, if you haven't already done so, create a query that includes the two tables. Next, create a form based on this query, including all the fields you want displayed. Then simply:

Add a combo box to your form. The Combobox Wizard will pop up

Select "Find a record based on the value I selected in my combobox."

From the query the form is based on, click on the field you're searching by (your ID field) to move it to the right side.

Hit Next.

Size the column appropriately.

Hit Next.

Name the combobox.

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.

Welome to TheScripts!

Linq ;0)>