Auto update fields on selection

[potentus]

Hi,

I am looking to have a form, where when I select one field in a combo
box, it automatically updates all the other fields to match that list

so for example.. I have a table with 3 fields
telephone
first name
last name


So I want a drop down box on the form, and when I choose the telephone
number i want, it automatically shows the first and last name with
it...

Additionally I would want to be able to choose a last name, and it
show the telephone and first name associated

Access 2003

Thanks in advance