Correlate Fields

[Michelle]

Hi, want to have a drop down field automatcally correlate with another field.
Example. Drop down field is a name. i want the next field to automatically
fill with the person phone number, and have them be linked so i dont have to
select the phone number or maunally type it in. is this possible?

 

[Jeanette Cunningham]

Hi Michelle,
In the row source for the combo, include the phone number field in the
query.
Add an extra column to the combo.
Set the width of this extra column to 0, so it doesn't show in the combo.

Put an unbound text box on the form.
Give the textbox a control source of
=Me.NameOfCombo.Column(n)
You can lock and disable the text box if you want to prevent users from
editing the phone number.

n is the number of the column that has the phone no.
A combo has its first column numbered as 0, the second one as 1 etc.
Replace NameOfCombo with the real name of the combo.


Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia