Populating 3 Fields at the same time via List Box

[CoffeeManOhYesIAm]

==================
MS-Access 2002 sp3
==================

Hi everyone,

I've got a brand-new table with 7 fields. Fields 1, 2, 3 need to get their information from another table linked via an ODBC connection. I would like to be able to use a List Box on Field 1 to select the proper row from the ODBC linked table, and then have Fields 2 & 3 automatically fill in with their info from the same record in the linked table.

I'm pretty new to this, so I have no idea if I can do this or not.

Any help would be greatly appreciated!

Thanks,

Geoff

 

[PHV]

Have a look at the Column property of the ListBox object.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886