Select Value from Listbox to autopopulate fields

[ccg_0004]

I have a form for tool repair that has the underlying table, repair details.

I also have a table that updates that latest location for a given tool, transporttable.

I have a table that stores all the tools' serial numbers. This is the recordsource for the "select tool" list box on the Repair form.

What I want is this:
When the tool is selected from the list box on the Repair form, the fields for the current location of the tool (stored in the transport table) are automatically populated into the Repair form.

is this possible?

 

[ajetrumpet]

Read this first:
http://support.microsoft.com/kb/319482/en-us

The same concept applies to list boxes too..