how to set value of text bounded on combo box?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

ghost - 15 Jan 2008 06:35 GMT

Hi,
I have a combo box with row sours of a table, and there is a text box. What
I want to do is once the user selects a value from the combo box, the text
box should be filled by a specific data. For example, the combo box has list
of names, and once the user select the name; the text box shows the phone
number of the selected name automatically.
Note: both the name and phone number are in the same table.
How can I do that?

Reply to this Message

Larry Daugherty - 15 Jan 2008 06:50 GMT

Make sure that the query for the combobox returns both the name and
phone number. The Phone number does not have to be visible in the
combobox.

In the combobox AfterUpdate Event:

me!txtPhone=me!cboGetPhone.column(n)

HTH

Signature

-Larry-
--

> Hi,
> I have a combo box with row sours of a table, and there is a text box. What
[quoted text clipped - 4 lines]
> Note: both the name and phone number are in the same table.
> How can I do that?

Reply to this Message

ghost - 15 Jan 2008 07:19 GMT

thank you Larry but the value of the txtbox returns to a " name" not number,
please advice?

> Make sure that the query for the combobox returns both the name and
> phone number. The Phone number does not have to be visible in the
[quoted text clipped - 17 lines]
> > Note: both the name and phone number are in the same table.
> > How can I do that?

Reply to this Message