Newbie Help with form

[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

 

[John W. Vinson]

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...

Do you want to UPDATE - i.e. copy the first name and last name from one table
and insert them into a different table, or into a new record of this form's
table?

Or do you want to FIND - navigate the form so that it's displaying the data
stored in the table for the selected record?

Or do want to just DISPLAY - have the form based on one table, but simply show
(for the user's information) the other fields in the combo box's rowsource
table?

Any of these can be done, but they are different.

My guess is that you want the second of these; if so, delete any combo box you
now have (unless you need it for some other purpose), and turn on the magic
wand icon in the toolbox. Create a new Combo box and choose the option "use
this combo to find a record".

If that's not the situation post back.